Hi, I have a question regarding how i should set my tables up after a team meeting telling me what they needed to add at their data entry point.
I have a processing database started. learned on the run and it is working but i know i need help with database. the users enter multiple company dockets on daily basis to get the information on the hours worked or material supplied to allow the evidence to be caught for when payment claims are made at the end of each month.
Now to begin with it was fine. i had a set of tables that worked. now with extras required i am confused. i have the end user entering a large amount of data from one docket. i wanted to know if i should create tables for each type of product used that day to allow the docket table not to be so large?
At the moment the base table before normalisation is as follows. all of the information from the docket goes to this table. then i create queries to separate the information. i have a few forms for different types of dockets to allow it not to be too confusing for entry operator. the machine docket requires times of operator and machine also any attachments(Attach)GPS(Addon1),Water(Addon2),Fuel, tools,etc(Misc)
docketNumber/DocketDate/CompanyID/Operator/ResourceID/CostCode/Location/StartTime/Breaks/FinishTime/TotalTime/VehicleStart/VehicleFinish/TotalVehicle/
TotalQuantity/Attach/Addon1/Addon2/Misc/Comments.
should i break this table down or is it fine to use as the shell that stores the base data input and then get the information required via queries?