Sorry for the newbie question! I have 4 tables: 1) companies, 2) clients, 3) locations, 4) employees. Each company has several clients, who each have many locations. Each location has its employees.
Someone from a company has to be able to:
- Sign up their company, then push a button to go to "clients" page (layout) to sign up a client.
- From each client page, they need to push a button to go to the Locations layout to put in several locations for this client.
- The employees will be automatically assigned to the locations via a zipcode relationship.
What's the basic theory on how to accomplish this?
Sorry again, I'm a novice, just coming from FMP 3!
