Assembly Parts Listing Table with Parts Table
I have an operational Filemaker Pro 11 database of about 5000 parts used in various ways to make different assemblies for manufacturing. I would like to design an assembly database where I can discretely enter each part number - up to 35 for each assembly - and it will load from the relational Parts DB, the cost and part name. Brute force would have me adding 35 fields for part number, name and cost but that seems crude and not elegant. What am I missing? Should I use a portal or repeating fields? I am stuck here. Thanks.