Access 2007 Subform Order Entry
Hello Experts,
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?
CF
Database1.accdb
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?
CF
Database1.accdb
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Helen Feddema
That will automatically create new records in the subform as needed, with the linking field value filled in.
ASKER
Okay guys,
I am loosing it with this one. I have tried many times to no avail and really need some further help.
Enclosed is my database with the forms, relationships and queries I have created as per the reference material provided by Capricorn1.
As per my initial post, I need to be able to create a load by entering the data on the form, capturing it, adding the data to the tblLoads table, as well as being able to add / delete / edit additional charges inside the subform I have created.
Ideally, the additional charges would be added to the tblLoadsAddChargeDetails table at the same time as creating my load.
Any assistance would be greatly appreciated.
CF
SAMPLE.accdb
I am loosing it with this one. I have tried many times to no avail and really need some further help.
Enclosed is my database with the forms, relationships and queries I have created as per the reference material provided by Capricorn1.
As per my initial post, I need to be able to create a load by entering the data on the form, capturing it, adding the data to the tblLoads table, as well as being able to add / delete / edit additional charges inside the subform I have created.
Ideally, the additional charges would be added to the tblLoadsAddChargeDetails table at the same time as creating my load.
Any assistance would be greatly appreciated.
CF
SAMPLE.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great help. Got it now. Thanks