Hi,

I am not sure if this particular question has been asked before:  I have designed a database using (modified) normalization.  Two of the forms: frmAgency and frmAgencyVenue, are listed below with the relevant fields.

frmAgency

AgencyID (Number field)

AgencyName (Single Line field)

frmAgencyVenue

AgencyVenueID (Number field)

cboAgencyID (Lookup field)**

AgencyID (Number field)

VenueName (Single Line field)

** the cboAgencyID looks up the AgencyName from the frmAgency form.  I then use the Fetch Record command & set variable command to set the AgencyID number to the proper record from frmAgency.

I want to create a new form (frmInterpEvent) with the following relevant fields:

frmInterpEvent

InterpEventID (Number field)

cboAgencyID (Lookup field)**

cboAgencyVenueID (Lookup field)***

** cboAgencyID looks up the AgencyName from frmAgency.

***cboAgencyVenueID looks up the VenueName from frmAgencyVenue

What I would like to do is filter the cboAgencyVenueID based on the selection from cboAgencyID field, but because the second references a different form from the first, can this be done?  Would I need to do this using script?

Thanks,

Leo

BTW, Creator rocks!