TechNumber - from employee
BillingLevel - From billing level
Billing - all billing codes in system and our billing price
BillingLevel - each technician has one of 4 billing levels
WorkOrder - technicians work orders
technumber - from employee
accountnumber - from customer
The question marks represent where I am stuck. What I want is for the technician to be able to enter their own workorders along with their billing codes and ammounts. What I am running into trouble with is how to set up the line items in the workorder table so that I am not just putting like 10 fields in the work order table (lineitem1, lineitem2, etc.). Is there a way to set this table up so that they can enter as many or as few line items as they wish???
You have to create another table that will be linked to the Workorders table by a One (Workorders table) to Many (New table) relationship. Each row in the Workorders table can then have one or more rows associated to it in this new table, the ???????? line in the workorders table holding the foreign keys to new table.