I'm trying to create a database for creating Work Orders. My company performs maintenance & other construction for several property managers, so I have customers that have several properties. My goal is to have a system of creating printout WOs to hand off & to keep track of the status & who each WO is assigned to.
I have 4 tables: Customers, Properties, Vendors, & Work Orders
The customers table has customer names & basic contact info
The Properties table has property address along with customer names that can be selected in a dropdown box.
The Work Order shows the property, customer, description, vendor, due date, status, ect.
I'm wanting the customer field to auto-fill each time I input the property, so that I don't have to refer to the other table each time to know which customer owns which property.