How do you create a relationship with two child match keys?
I am creating a query to base a form upon.
I have a case table related to a people table. The people are either typeA
or type B.
I want a caseID--->caseID_typeA
caseID--->caseID_typeB
For some reason I did this and in the Query it said ambigous relationship.
I want the user to be able to select if he wants to enter a typeA person or
a TypeB person in cases in order to do data entry.
Do I need a type field in the parent file? Should it be a popup? If he
selects it and types in the data I want it to auto-enter the recordID and
type and data in the child record. I have a type field in the child file.
I want a calculation to enter the type in the child file.
Is this a concatenated match key?
--
Janis
|
Similar Threads
