I have one nagging issue I can’t seem to figure out, that effect’s many pages and would appreciate any New ideas, as I’m out.
I have a user “client name” drop down menu, that when clicked, creates a “new item” then goes to a form,… for them to fill out the rest of the info.
The client email shows in the products database. great,
That all works.
What I can’t seem to figure out is how to add that newly created “Products” unique ID to the Client’s database.
I want to be able to exclude clients with no “products of that type” on look up.
So how when I create a new product, on the next step also add that unique id into the clients database?
Btw, list of clients, client, nothing seems to work.
I think I have tried every way but the way it works. Probably something simple. Thanks for any thoughts.
You are trying to make changes to a list of Clients, while the “List to change” is referencing one single thing/client.
Step 2 should be Make changes to Client and the field to change: Product(of data type Bid Product) = Result of step 1
probably the better way to do this is with the database structure
if there are not that many clients per product then yes you can keep a list of clients on the product - but if there are many then that’s an inefficient way to do it
if there are limited products you could store it on the client, but again if there are many it’s very inefficient to store a long list this way
better option is a separate data type
client_purchase - client, product, status
your search could function several ways depending on the data structure
- search for clients minus list (search for products where product is product) products clients
- search for clients where product list doesn’t contain product
- search for clients minus search for client_purchases where purchase is product
essentially 1 and 3 minus off a second search from the first search
2 does 1 search with constraints
#3 would be the most flexible and scalable
if you wanted to filter by products type (not the product itself) then I’d also store the type on the client_products data - saves doing a nested search which can be slow and WU high
