AnsweredAssumed Answered

Relationships in FMP7

Question asked by dicksmith on Sep 26, 2010
Latest reply on Sep 27, 2010 by dicksmith


Relationships in FMP7


I think I'm over my head in relationships. I have an organization with Members, and Items Bought by those members. Many members can buy many items, so I relate those tables with a Members and Items Join Table. But how can I handle the Number of each Item bought by a Member, as well as the Price paid per each of those items?  I want to display, for each member, the number of Items bought and the price for each item, and also display, for each Item,  which members are purchasers  and the price and quantity ordered by each member.  Can anyone help?  I'm a pretty raw newbie.  Thanks.