4. Configuring Fields to use the Lookup and Capture Files

Back to Walkthrough

First, lets attach the ItemIDField and QtyField Screen Fields to the Capture File.

1. Click on ItemIDField in the Tree View.  If the Details tab is not already the active tab, click the Details tab.

Check  Write Data to the following file and select Capture, field: ItemID

2. Click on QtyField in the Tree View.  The Details tab should continue to be the active tab.

Check Write Data to the following file and select Capture, field: QTY

Next, lets attach the ItemIDField and DescField Screen Fields to the ItemsLookup File.

3. Click on ItemIDField in the Tree View. Click on the Validation tab.

Designate as the Match field for the lookup file: ItemsLookup, field: ItemID.

We want to make the program locate the correct Lookup record that matches the value of ItemIDField every time we leave the ItemIDField Screen Field.

4. Click on DescriptionField in the Tree View.  Click on the Details tab.

Leave the Data section as is. 

Instead, under Default Value, check Get default value from lookup file and select ItemsLookup, field: DESC

1 and 2 set up ItemIDField and QtyField to be saved to the Capture File as ItemID and QTY.

3 and 4 set up the lookup file to align to the first row where ItemID matches of ItemIDField.  After the alignment, DescriptionField will use the value of the DESC column in that row as its default value.

Continue on to Step 5, and finish up your program with some Final Touches

Back to Walkthrough

Copyright © 2007, American Microsystems, Ltd.