Help with simple database concept

[BerkshireGuy]

Can someone lead me in the right direction for the following:

I have two tables:

tblTelemedCasesFromMainFrame with fields, PolicyNumber, Underwriter

then a table called tblTelemedQuestion with fields
TelemedquestionID
PolicyNumber
NumberofCasesOrder
ProcessComplete
Reason

Basically I want to setup a form that allows the Underwriter to select
their initials from a dropdown, and then have another dropdown which
the recordsource will only be their policies.

Then once they select the policy number, it allows the
NumberOfCasesOrder, ProcessComplete, and Reason fields to be entered.

Thanks
B

[pietlinden]

there's code for this at AccessWeb.
http://www.mvps.org/access/forms/frm0028.htm

part 2 of the question - I guess in the OnCurrent event of the form,
disable the NumberOfCasesOrder, ProcessComplete, and Reason fields.
then in the AfterUpdate event fo the PolicyNumber field, check for null
or whatever, and then enable the 3 fields again.

[Ed Robichaud]

One of the common setups would be to have a single style form with a record
source of tblMainFrame. Use the combo-box wizard to create a locater type
control to find a specific underwriter. Add a datasheet or continuous type
subform with the record source of tblMainFrame, linked to the [underwriter]
of the main form. Add a second subform with a record source of
tblTelMedQuestion, linked by [policynumber] to the first subform. Now, when
you select a specific underwriter, the first subform will show all related
policynumbers, and the second subform will show the TelemedQuestion record
for that policynumber.
-Ed

"BerkshireGuy" <bd*****@yahoo.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Can someone lead me in the right direction for the following:

I have two tables:

tblTelemedCasesFromMainFrame with fields, PolicyNumber, Underwriter

then a table called tblTelemedQuestion with fields
TelemedquestionID
PolicyNumber
NumberofCasesOrder
ProcessComplete
Reason

Basically I want to setup a form that allows the Underwriter to select
their initials from a dropdown, and then have another dropdown which
the recordsource will only be their policies.

Then once they select the policy number, it allows the
NumberOfCasesOrder, ProcessComplete, and Reason fields to be entered.

Thanks
B