Hi, I am totally new to filemaker and have made a database containing a materials table which holds records of all different materials and prices per unit of measurement.
I also have a quotation table which holds the same materials in separate fields.
Is there any way to create a relationship between the name field in the materials table and the separate fields in the quotation table, therefor creating a relationship of several fields and the one name field or should I just give up?
I would be so happy with any response as I can't seem to figure this one out.