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.