luisrosario

Table relationship

Discussion created by luisrosario on Mar 7, 2013
Latest reply on Mar 12, 2013 by luisrosario

I represent a company for which I sell, or rent machines and also give technical assistance in these machines.

I'm trying to create an application that will help me in my daily control.

I'm having trouble making the relationship between tables.

I would appreciate if someone can help me.
Starting as a principle that for every client I have the following situations:
Each customer can have one or many machines.
Each time I visit a customer, i have to do a visit report where I write down the problems or

malfunctions of the machines, this report must include the date of the visit.
I need to chart dates for every 60 days to make a visit to each customer.
Every 15 days I have to bill for the company I represent, the various visits I made to my clients, where I include the travel expenses and the agreed value for each assistance.

 

I think I need 5 main tables, Customers, Machines, Visits/Dates, Invoicing and Visit Reports.

 

Where should I place the primary key and foreign key, and how to relate them?

 

FileMaker Pro 11 Adv.

 

Thanks

Outcomes