9 Replies Latest reply on Nov 16, 2013 6:20 PM by philmodjunk

    Relationships 101 (FMPro 12)



      Relationships 101 (FMPro 12)


           Given that a customer will reference only one state and a state will have many customers:  Objective is to lookup a customer, then go to the table that shows the customer’s state that will list the regulations of that state. Thus, a customer and a state table are setup. The customer table has customer’s contact info; the state table lists the states and its regulations.   Any suggestions on tables/relationships? 

           Thanks, Hal