IntelliTrack Check In/Out - Manual (Page 417)

Appendix C
Microsoft Access Integration
389
11. Place the cursor in the BINLOC field and select BINLOC from the
drop-down list.
12. 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; you are prompted to save it. Save the query as Import
BINLOC. Click OK.
14. To verify data is in the Bin Location table: select the Bin Location tab
and open it to view the imported data.
Query Import
Data –
Inventory
Table To transfer the imported inventory data, create a select query based on the
imported data and then update the inventory table by running an append
query.
1. To run a select query based on the imported inventory data, click Cre-
ate > Other > Query Design.
2. A Show Table window appears; select the inventory table that you cre-
ated when you imported your inventory data and then click the Add
button. Click the Close button next to close the Show Table window
and view the table’s fields. The table is placed in the upper pane of the
query window. The Inventory table contains many field and stores
common product information. Only import the ItemNo fields. Review
the data structure of the Inventory table to determine which fields to
drag to the Field row.
3. Click the Design tab and select Results > Run.
4. The query runs and the data in the new inventory table appears. Verify
that the query contains the new data for the assets table.
5. To update the Inventory table with the new data, run an append query.
To run an append Query, place the window in Design View.
6. Select Design > Append.
7. An Append dialog appears; click the drop-down arrow in the Table
Name field and select the Inventory table. Select the Current Data-
base option. Click OK.
8. Place the cursor in the Append To row in the corresponding column of
the imported fields and select the ItemNo and any other corresponding
fields from the Inventory table.
9. 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.
2283.book Page 389 Thursday, July 9, 2009 11:26 AM