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?

Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
* your main form is unbound
    -The main form shows data from the "one" side of the relationship.
    -The subform shows data from the "many" side of the relationship.

you can not achieve this with an unbound main form.

you need to read and understand the content of the link i posted.

maybe this will help
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
Helen FeddemaCommented:
That will automatically create new records in the subform as needed, with the linking field value filled in.
creativefusionAuthor Commented:
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.

creativefusionAuthor Commented:
Great help. Got it now. Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.