Unfortunately, the uploaded image is too small with too low a resolution. I can't zoom in on it to a point where I can read the text in it.
I think I see this relationship:
Table1:ProductID = Table2::ProductID
If so, then a looked up value setting will not work for ProductID. You can set up other fields in one table to look up date from other fields in the second table when you enter or selelct a ProductID in the ProductID field, but you have to have matching values in both fields before this will work so it won't work for the matching field's value--only other fields in the table.
A typical solution to this issue is to use a a drop down list or pop up menu of ProductID's with a Product Description field included as the second field so that you can select the correct Product. Once you have selected a product, any lookups on other fields will correctly copy data.
Thank you for the response.
I think you have it right that i am just doing this wrong.
Apologies, but please understand, i have been combing through the instuctional materials, forums, knowledgebase and external filemaker support sites for 2 days now.
What i am trying to do is simple. I have one table already established with field 'product ID'. that table has hundreds of records related to product id. I want to create another table, also based on product ID, that has supplemental information for each product ID.
How do i do this! i know it is such a simple thing. Apologies.