Darshan Hiranandani : Creating a Form for Multiple Entries in a Table (Same Form) - Dispatch Details

[darshanhiranandani24]

Hello everyone,

I'm Darshan Hiranandani, I have a table called "Dispatch Details" with the following columns:

1. Dispatch Date
2. Party Name
3. Truck Number
4. Freight Charges

I’ve created a form that works for single dispatch entries. However, I now need a solution for cases where multiple parties are being dispatched using the same truck.

Specifically, I’m looking for a way to:

1. Enter multiple dispatch entries for different parties in the same form.
2. Calculate the freight charges for all the parties whose materials are being delivered in a single truck.

Does anyone have suggestions on how to structure this form or approach the data entry process for such cases?

Thanks in advance for your help!
Regards
Darshan Hiranandani

 

[plog]

You need more than a new form, you need a new table:

Parties
partyID, autonumber primary key
IDDispatch, number, this will hold the primary key numeric id in DispatchDetails
partyName, text, data that was in PartyName of DispatchDetails is here now
FreightCharges, number, data that was in FreightCharges is here now

Formwise, you will have a main form based on DispatchDetails that will have have a subform based on the above Parties table. With that you will be able to enter as many Parties records into it as needed all on the same form.

 

[XPS35]

I believe that we are once again dealing with a member who asks questions but never responds to the answers he receives. So don't waste your time.

 

[LarryE]

See this same question asked by another member:

Solved - How to make a form to enter multiple entries in table with same form

Hi all, i have a table named "Dispatch details". It has following columns, 1. Dispatch Date 2. Party Name 3. Truck Number 4. Freight Charges I have created a single entry form to enter all details. As per single case dispatch this works but what in case where i have to dispatch for more than...

www.access-programmers.co.uk