AnsweredAssumed Answered

Creating links and tables

Question asked by squiggle on Oct 10, 2009
Latest reply on Oct 15, 2009 by squiggle


Creating links and tables


I'm using FMP 10 on XP pro. I have multiple Sales Rep Groups (10 of them) that sell my products. There are an average of 7 sales reps in each group (est. total of 70 sales reps). I want to associate their Sales Rep Group name, phone # and email address with them. So heres what I'm trying to do: Let's say a store buys 3 widgets from us and John Doe sold them these widgets. I will look up the store in my database and when I select a sales rep name (Doe, John) I want all of the sales rep info to appear like this:

Doe, John

XZY Sales Rep Group



Hope this explains it well enough. Thank you