IntelliTrack Stockroom Inventory - Manual (Page 344)

I NTELLI T RACK S TOCKROOM V 7.0
User Manual
316
7. After the data is imported into the Stockroom system, build and run sev-
eral queries transferring the imported data into the following Stockroom
tables:
Site table
Bin Location table
Inventory table
Inventory by Location table
Query Import
Data – Site
Table To transfer the imported data into the Site table, create a select query based
on the imported data and then update the Site table by running an append
query.
1. To run a query based on the imported site data, click Create > Other >
Query Design.
2. A Show Table window appears; select the site table that you created
when you imported your site data and then click the Add button.
3. Click Close to view the table’s fields. The table has its own window in
the header of the Query window.
4. Drag the Site field to the cell in the first column of the Field row.
5. Click Design > Results > Run.
6. The query runs and the data in the query appears. Verify that the query
returned the records that you want to append.
7. To update the Sites table with the new data, run an append query. To
run an append query, place the window in Design View.
8. Select Design > Append.
9. An Append dialog appears; click the drop-down arrow in the Table
Name field and select Sites from the Table Name list. Select the Cur-
rent Database option. Click OK.
10. Place the cursor in the Append To row, in the first column of the
imported field.
11. Select the Site field from the Sites table.
12. Next, select Results > Run. A message appears notifying you that you
are about to append the table. To continue, click Yes. (To cancel
appending the data, click No.)
13. Close the query. A dialog box opens prompting you to save the design
of Query 1. Click Yes. Save the query as Import Sites. Click OK.
14. To verify the data is in the Site table:
Open the Site table from the Navigation Pane to view the imported
data.
2289.book Page 316 Thursday, July 9, 2009 2:35 PM