create two match keys in the child file

  • Thread starter FilemakerPro_Developer
  • Start date
F

FilemakerPro_Developer

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create a form, link master and child type fields 4
Create a dynamic master file 1
VBA word change keys 0
Transfer data between two tables 3
Query with if statement 0
Validation in child form 1
Child Table With Two Parent Tables 4
How to concatenate child fields? 5

Top