I have a caseID in a cases table I want to relate it to two child key fields
based on a popup "type" field chosen by the user. The child table is People.
cases----typeAID
cases----typeBID
HOw do I get the caseID input into the child table so that I can match the
keys? ? I have a serialID field in the People table but it is not related
to anything .
Right now I'm in the query builder and I have the two one to many
relationships
so I assume I create a calculation in the query builder, if it is type A
then input the case# into type ASerialID else if it is type B in the type
popup input type B in the Type field and the case number in the TypeBID.
thanks,
--

Janis