Combo Box question

  • Thread starter Thread starter Remco
  • Start date Start date
R

Remco

OK, programming my first DB ever I run into a problem I do
not know how to resolve.

In a form the user has to select a vendor. In case a
vendor already does have vendor contacts, I want only the
vendor contact(s) related to that particular vendor to be
visible. In case the vendor does not have any contacts in
the database yet, I want the user to be allowed to key in
the (new) contact.

How should I proceed?

TIA,
Remco
 
I guess both tables are related.
One solution would be to include a subform (data source
obtained from vendor contacts) to show the desired data or
key the new one. The relationship between the two tables
recover the desired data (if any) IF the list takes you to
the appropiated record (You can create such a list with
the wizard).
Hope it helps,

Damian
 
Back
Top