Guiding Through Steps (Opinion Please)

[Dalagrath]

for my work, I am creating an "Interactive Map" of the property. With this map, we are going to allow people to follow these steps:

1) Scan Item Barcodes Into a Form
2) Select using the map where items are going to



Now, I have the basic table down and how to get the information using forms to plop information onto the table. What I am looking for however, is how to combine the item barcodes and information from one form, and the location information of another onto a single table. Any opinions or thoughts would grealty help!

[kennejd]

This sort of sounds like an orders table....where you would store the item_id from the items table and the location_id from the location table. You'll have your main entry form that will be linked to the orders table. You can use whatever method you want to fill in the various id fields....combo box, list box....or pop up form. On the pop up form you would write some code to update the main form on close.