September 24, 201510 yr Newbies Hello, I'm working in a manufacturing company and i creating a filemaker solution. I' trying to make some relationship between some tables and it's now working for now. I will use a comparable subject to explain you my challange. Example: I have a restaurant, and i want to create Receipe. So have have multiples tables as Ingredients and the receipe. It's a many to many relationship so i have to create a list of ingredients. So in my table ingredients i have list of ingredients as egg, mayo chicken etc. i have to create multiple field like ingredient title, quantity etc. In my receipe table i have list of final receipe . ex: Omelet and checkien sandwitch etc. So i need a portal to see those ingredients in my receipe.right? Do i need something else? IM a little bit confused thank you for your help
September 24, 201510 yr It's a many to many relationship Yes, it is a many-to-many relationship, and that's why you will need three tables. See, for example: http://fmforums.com/topic/59206-relation-ships-lookup/?do=findComment&comment=280194
Create an account or sign in to comment