AnsweredAssumed Answered

Look up relationships

Question asked by walterjump on Nov 18, 2016
Latest reply on Nov 18, 2016 by philmodjunk

I am relatively new to FileMaker. I have done look up relationships be fore where there is a one field to one field relationship. I need to do a relationship of many to one. I am developing a database that has one table for building an item  This consists of many elements(between 5 and 20). I want to relate the various part needed to an elements table that contains the description, ID, cost, cost units, etc.. The manufacturing table is linked by ID of part to ID of elements table. The manufacturing table has a list of elements to use in manufacture, but different grades can be used for different items. For example the manufacturing table has coating1, coating2, coating3, etc. The ID in these fields is supposed to link to the ID in the elements table and then look up the description, cost, etc and copy it into the manufacturing table. When I try this it will only look up the first item and then copies that information into all the lookup fields (coating1 cost, coating2cost, etc). What do I need to do to get each manufacturing ID looked up separately and the appropriated information copied into the manufacturing table?

Outcomes