Advice on best way to setup DB

[Stuart Liles]

Hi, i am trying to make a filemaker db for a courier business me and a friend are doing. I have a bit of knowledge on fm and just wanted some expert advise on the best way to setup the whole db , layouts and relationships.

I have a friend creating the booking website with the payment module and will import to pm db on booking paid for (somehow   )

I have attached the image to give an idea how i want things laid out and some layouts will be for ipad mini and some on the pc which isnt too much trouble but more the initial setup. 

Please if you have nothing helpful to say dont say anything at all. 

I appreciate any assistance. 

Thanks

Stu

Edited August 28, 2016 by Stuart Liles

[comment]

What is the difference between a Booking and an Order? And why does the booking layout assume that the pickup is not at the client's address?

[Stuart Liles]

Hi. Booking is where inputing the new job. Order layout is the confirmed booking and in the system to look at details.

 

Client might be a business that uses us to pickup from one location to deliver to another. 

 

Hope that makes sense.