posted on all 3 forums...
I think you may need the following tables:
Line Items (Join table)
I don't know what registry means in this scenario and also what is a client? Are clients agents?
This would be more of a normalized type structure.
With the proper relationships you can have portals on these tables that would show the information you are seeking.
This makes reporting much easier.
hi and tanks for your answer.
for registry i mean customer masters.
i have 1 database with le following tables:
brands (is the same of suppliers)
in the customer masters table there is a field with the name of agent and in another field there are all brand that the customers buy.
in the agents table there is a field with all brand that he sell to customers
in another table i think to insert the name of customers finding agent or brand as parameter. but I would like the data generated from the search and displayed in the portal to automatically generate a record for each line. But I think it's not possible and so I think I must first create records in a new table and then display the records in that table with the filter from the initial search (agent or brand)