IntelliTrack Check In/Out - Manual (Page 416)

I NTELLI T RACK C HECK I N -O UT V 7.0
User Manual
388
9. An Append dialog appears; click the drop-down arrow in the Table
Name field and select the Sites table. Select the Current Database
option. Click OK.
10. Select the Append To field. Place the cursor in the Append To row in
the first column of the imported field. Select the Site field from the
Sites table.
11. Next, select Results > Run. A message appears notifying you that you
are about to append the table. To continue, click Yes. To cancel append-
ing the data, click No.
12. Close the query; you will be prompted to save it. Save the query as
Import Sites. Click OK.
13. Click on the Table tab.
To verify the data is in the Site table:
Select the Site table.
Click Open to view the imported data.
Query Import
Data – Bin
Location
Table To transfer the imported location data into the bin location table, create a
select query based on the imported data and then update the bin location
table by running an append query.
1. To run a select query based on the imported location data, click Create
> Other > Query Design.
2. A Show Table window appears; select the location table that you cre-
ated when you imported your location data and then click the Add but-
ton. Next, click Close to close the Show Table window.
3. The Query window appears. A table window appears in the Query win-
dow.
4. Drag the Site field to the first column of the Field row and the Bin
Location field to the second column of the Field row.
5. Click the Design tab and select Results > Run.
6. The query runs and the data in the bin location import file appears.
7. To update the Bin Location table with the new data, run an append
query. To run an append query, place the window in Design View by
selecting View > Design.
8. Next, select Design tab > Append.
9. An append dialog appears; click the drop-down arrow in the Table
Name field and select the Bin Location table. Select the Current
Database option. Click OK.
10. Place the cursor in the Append To row in the Site field and select a Site
from the drop-down list.
2283.book Page 388 Thursday, July 9, 2009 11:26 AM