I am building a database to track truck loads of product from location x to location y. The sole purpose of this database is to track distances travelled and associated costs.
My database currently contains three tables:
tblLoads which contains the main information for the load (similar to an order header table)
tblLoadsAddChargeDetails which contains additional line charges for the load. Noting that some loads might not have any additional charges whereas other could have many. (similar to an order details table)
tblAdditional which contains each additional charge and relevant cost
The process I have in mind is that when I open a parent form, a load ID is generated and added to tblLoads table automatically. Then, I will enter the details of each load and if required, add additional charge lines for each.
With my limited knowledge of subforms and parent/child table links, I am having some difficulty working out the best way of developing the functionality required to allow me to add/edit and delete the additional charge lines for each load using a subform within a parent form containing the load details (load header information).
Could someone please provide me with something that would best suit my needs?