New form question

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I am a beginer with Acess. I've created a few tables in my
database, and I'm tryin to reference a value into a table
from a different table, based on the primary key.

FOR EXAMPLE:

TABLE 1:
SSN FNAME LAST NAME GROUPID POLICYID COPAY

I want the Copay to come from Table 2

TABLE 2:

INSURANCENAME GROUPID COPAY

based on the group ID. because each Group ID has a
different CoPay.

(I know I can restructe this differently, but its an
example for a project I'm doing.
 
In form design view, place a combo box for your copay
field, and follow the wizard. The recommended strategy is
to hide the key column so that the resulting control
displays the description of the CoPay. Actually, however,
only the integer code is actually stored in your Table 1
table.

HTH
Kevin Sprinkel
Becker & Frondorf
 
Back
Top