H Posted February 25, 2016 Share Posted February 25, 2016 Hi i have a manufacturing solution which goes as follow. every product has many ingredients. every ingredient can be in many products. the ingredients get selcted to a product through a portal with drop downs. unfortanately i can`t seem to display the products which relate to the ingredients. where am i going wrong, how would the relationships be different thant the one to many i have many time already in my solution. please could someone help me out , i would greatly appreciate it. Link to comment Share on other sites More sharing options...
comment Posted February 25, 2016 Share Posted February 25, 2016 You need three tables: Products, Ingredients and a join table of Quantities. See a basic demo of a join table here:http://fmforums.com/topic/50942-portal-grouping-problem/#comment-239210 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2983 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