create a form, link master and child type fields

[Guest]

I have caseID-->caseID relationship from cases to evaluations.

There is a partyType field in both tables. I need two relationships to child
file
one for typeA and one for typeB. CaseID +TypeA and CaseID + Type B. In the
data entry subform the user can choose a list box showing which type as they
create new records. I think I only need one subform for data entry because
the type field captures the type on each datasheet. Later I can display the
data for each type in separate subforms?

In any case,I have the CaseID::caseID relationship but can't figure out how
to link the type fields?

Someone said you can link the master field and child field in the subform
linking properties. I went to control source in the subform and typed CaseID
+ partyType
and I did the same in the master form. I still can't enter data in the
form.


tia,

 

[Douglas J. Steele]

If you have more than one field to use for the link, you type the names of
the fields separated by a semi-colon:

CaseID; partyType

 

[John Vinson]

Someone said you can link the master field and child field in the subform
linking properties. I went to control source in the subform and typed CaseID
+ partyType
and I did the same in the master form. I still can't enter data in the
form.

The person was not suggesting any Control Source.

Instead, look at the Subform properties - select the subform control,
the "box" containing the subform (not the form within that box).

It's got a Master Link Field property and a Child Link Field property.

Set them both to

[CaseID];[PartyType]

using brackets and a semicolon as a delimiter.

This will cause the subform to link by, and inherit, both mainform
fields.

John W. Vinson[MVP]

 

[Guest]

Hey John:
I did exactly as you said. I clicked on the little black box on the subform
to get the properties.It does say table name subform
however there is no Master field link or child field link.
Does that mean that I have to link them first on the table datasheets?
If so exactly which field goes where?
thanks,
--
Janis

Someone said you can link the master field and child field in the subform
linking properties. I went to control source in the subform and typed CaseID
+ partyType
and I did the same in the master form. I still can't enter data in the
form.

The person was not suggesting any Control Source.

Instead, look at the Subform properties - select the subform control,
the "box" containing the subform (not the form within that box).

It's got a Master Link Field property and a Child Link Field property.

Set them both to

[CaseID];[PartyType]

using brackets and a semicolon as a delimiter.

This will cause the subform to link by, and inherit, both mainform
fields.

John W. Vinson[MVP]

 

[John Vinson]

Hey John:
I did exactly as you said. I clicked on the little black box on the subform
to get the properties.It does say table name subform
however there is no Master field link or child field link.
Does that mean that I have to link them first on the table datasheets?
If so exactly which field goes where?
thanks,

You're selecting the FORM inside the subform control. See other
thread.

John W. Vinson[MVP]