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?