Direct Lookup

[Steven Mak <smak@aehr.com>]

I've a form tied to a table customer which consist of three fields (ID,
Name, and Address).  I can use the navigator to move prior, next, last,
and first and see all fields changes.

Now, I want to convert the EditControl of ID to a DBLookupComboBox that
list all customer->ID from the customer table, and upon return set the
form to point to the selected ID record.

I managed to create a DBLookupCombox for the ID field but has the
following problems:

1) Click the DBLookupCombox and select a different ID only changes the
ID field only, the Name and Address did not change.

2) If click Post, I'll get a raised exception for duplicate key.