How to make a form to enter multiple entries in table with same form (5 Viewers)

[hrdpgajjar]

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 one parties in single truck ?

Also i need to calculate freight charges for all the parties material delivered in single truck.


second question is,
what if i need to deliver several trucks with several parties on same day?


I am confused here. Please guide me.


Thanks

 

[Gasman]

You do seem to want to make life hard for yourself.
Tables with spaces in the names, fields with spaces in the names

Normally this would be handled with a mainform/subform scenario, but that also relies on your data structure.

 

[LarryE]

This is a very basic table design problem. Please take a screenshot of your table relationship design and post it here so we can see what you have.
Use Database Tools > Relationships to view your relationships.

 

[mike60smart]

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 one parties in single truck ?

Also i need to calculate freight charges for all the parties material delivered in single truck.


second question is,
what if i need to deliver several trucks with several parties on same day?


I am confused here. Please guide me.


Thanks

Hi
Are you able to upload a copy of the database?

 

[LarryE]

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 one parties in single truck ?

Also i need to calculate freight charges for all the parties material delivered in single truck.


second question is,
what if i need to deliver several trucks with several parties on same day?


I am confused here. Please guide me.


Thanks

You will need a design something like this so:

1. Multiple Trucks
2. Make multiple deliveries on multiple dates
3. To multiple parties

Here is the file. From here you develop your forms, queries and reports. Add or delete fields in each table as needed.

 

[The_Doc_Man]

You are getting detailed advice from the others so I will provide a bit of overview advice.

You have run into a problem that is so common that nobody will be surprised. The solution to this problem is a process called "Database Normalization" and it is used to handle cases like yours where there is an action that is a response to a single event but might involve multiple people or multiple locations or some other "multiple elements" in response to the single cause.

You need to do a search to learn about normalization. Read a few articles and then you will know why you are being told about sub-tables or child tables. Just a hint on the search: If you use the SEARCH option in the upper right of the forum window (to the right of your login name), you can search for "Normalization" because this IS a database forum. However, in a general web search, you must look for "Database Normalization" because at least half-a-dozen other disciplines also use the term "normalization." Therefore, on a general web search, you must be specific enough to narrow the topic.

When you DO that search, you will get all sorts of hits. I recommend you look at the .EDU site hits first, then when you are starting to get a feel for it, go ahead to the .COM sites. There, the only reason isn't that the .COM sites are wrong. They just have something to sell you sometimes and it can be distracting at first.

 

[hrdpgajjar]

Hi
Are you able to upload a copy of the database?

here is the copy of my database. I have not assign any relationships yet. but help is appreciated

 

[hrdpgajjar]

You will need a design something like this so:

1. Multiple Trucks
2. Make multiple deliveries on multiple dates
3. To multiple parties

View attachment 117202
Here is the file. From here you develop your forms, queries and reports. Add or delete fields in each table as needed.

please take a look at the attached database of mine. Now how can i design a form for multiple entries?

 

[DickyP]

I know this post may seem a little dismissive or rude but it's not meant to be so please don't be offended. There are ideas above which will help solve your problem in the short term, but the nub of the problem depends on having a decent data structure to start with as suggested by the The Doc Man and others.

In excellent source for the necessary learning if you can get hold of a copy of 'Access Database Design & Programming' (ISBN 978-0596002732) which despite being more than 20 years old the chepters 2 - 7 are the best simple introduction to database design!

 

[mike60smart]

please take a look at the attached database of mine. Now how can i design a form for multiple entries?

Hi

Do Farmers call you to place Orders for Items which you then Dispatch

Please explain your process in more detail.