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,

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"FilemakerPro_Developer" <(E-Mail Removed)>
wrote in message news:9BABE35E-45E4-4AA4-9C30-(E-Mail Removed)...
>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,
>

On Mon, 1 Jan 2007 12:58:01 -0800, FilemakerPro_Developer
<(E-Mail Removed)> wrote:

>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]

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


"John Vinson" wrote:

> On Mon, 1 Jan 2007 12:58:01 -0800, FilemakerPro_Developer
> <(E-Mail Removed)> wrote:
>
> >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]
>

On Mon, 1 Jan 2007 16:43:00 -0800, FilemakerPro_Developer
<(E-Mail Removed)> wrote:

>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]