February 25, 201610 yr 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.
February 25, 201610 yr 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
Create an account or sign in to comment