building a (relatively simple) data entry form

[spence]

I have three tables:

TableCustomer (key field CustID)
TableProvider (key field ProvID)
TableContract (key field ContractID)

The three tables are linked together by the fact that TableContract contains
both CustID and ProvID, both in one to many relationships.)

I want to create a form that allows me to look up the customer, and then in
a subform choose a provider from a drop down, and then populate my contract
information. I’ve tried various queries and linkages to make this work but
I’m absolutely stumped. Any assistance would be greatly appreciated.

 

[Beetle]

Create a main form based on your TableCustomer (or a query thereof) with
a subform based on your TableContract (or a query). In the subform use
a combo box for selecting the Provider. The combo box would have properties
like the following;

Control Source: ProvID (from TableContract)
Row Source: Select ProvID, ProviderName From TableProvider
Order By ProviderName
Bound Column: 1
Column Count: 2
Column Widths: 0", 2" (or whatever width works best for the second column)

 

[spence]

Thank you so much. Worked like a charm. I don't know what I was doing to make
it hard.