Newbies doumlegare Posted September 24, 2015 Newbies Posted September 24, 2015 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
comment Posted September 24, 2015 Posted September 24, 2015 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
Recommended Posts
This topic is 3359 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now