Clarification of Portal setup
I am trying to create a filemaker solution to manage a product catalog. There is a main table with all my products and their details (product name, prices, etc.) Each product has a unique product id assigned. For each of these products I need to be able to search the products database, find related products and then capture the product id of those related products to a "related products" field. For example if there is a product called "brown couch" I want to be able to search for the other related products (brown lamp, brown rug, etc.). Then get the product ID for each of those and copy the numbers as a comma seperated list, into the 'related products field" of "brown couch".
I'm thinking the best way to do this is to add a portal to my products layout. I could then setup to search the portal to find the related items (ie search for brown). Look at the product id for each item in the search result and hand type those into the "related products field". If anyone has a better approach, please advise.
here's where I am stuck. Since all my product info is in the single table, I cannot create a portal (since it needs a second table with a relationship). Ithought I would simply duplicate the main products table as a new table called "related products" and then use "related producst table" to setup my portal. However, I cannot figure out how to avoid having to update both tables. Currently I have an entire layout set up to edit/work withthe main products table. I'd like the second 'related producst table' to be updated every time I edit a record, add a record or delete a record in the "main products table" I basically needthe two tables synchronized since I'm really only using the second table to make use of a portal possible.
Any suggestions or advice is greatly appreciated. I am a novice filemaker user and may be missing an easier approach to being able to search all the product info within the main products table layout.