Batch Update

[The Mad Jammer]

Hey now,

I have written a database for a client of mine that tracks shipping data. The application accepts information about items that are being shipped in containers via ocean freight. Each containers may carry several items. What I want to do is update all the records that have the same shipping information in one stroke. I want to develop a form that will have the container number, vessel name, ship date, arrival date, booking number, ship line, etc... and then be able to enter up to 30 record numbers that will be updated with the aforementioned information. When the UPDATE button is clicked a script will loop through each record number on the batch update form, find the record on the database, and update the shipping information fields with the information supplied.

I don't need to keep any of the information on the batch update form after it has updated the master database records. By and large, I just want the fields on the batch update form to be variables that will go away when the form is not in use.

Any good way to do this?

Thanks

The Mad Jammer

And Then...there was nothing