This is the way the database should be set up. There should be 1 record for
each product. If you want to display all Products that belong to a Company.
Then create a relationship from your file where the Company records are kept
to the Products database.
Use Company::Company fields (hopefully this is an ID) and then set up a
portal in the file that contains the records for each Company. What you will
get is a list of all Products that belong to that Company.
> I have a database of products owned by customers the problem is each product
> own has it1s own record. Example:
> Company A might own 6 different products and hence they are listed as 6
> different records.
> How can I combine all records into one so that company A is listed once in the
> database yet all the product they own are included in that record ?
> Any help greatly appreciate.
> If I am too confusing sorry, email me and I1ll try to explain it better