how do I repeat information into the database based on a number entered into a form, for example.
I have 20 bundles of pipe to collect from our client but need two vehicles to move them whilst placing the order into the database I enter the number of loads required to complete this order, this information needs to be replicated in the table twice so that two different vehicles can be allocated to the order.

Your help will be appreciated.

you should take a close look at the Northwind database example that comes with Access. You should definitely be normalizing a Customer/Order type database.

Normalization is when you evade the unnecessary repetition of data.

What factor determines how many loads you you need? Is there a rule?

"Life is a Database"

Thank you I'll take a look at northwind

there is not a particular factor it is based on a knowledge of the equipment in this case drill pipe but it could be anything we are required to move on behalf of our client

once again thanks for your help