two alternate match keys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
Click to expand...

I'm thinking that you've wandered into the wrong group here; last I
heard Filemaker (which is the product that I guess you're asking about
from your user handle) wasn't even a Microsoft product, and it
certainly bears no relation to Excel. Mind you, I haven't read the
business section this morning yet, so who knows...

Anyway, you might want to try comp.databases.filemaker down the
hall...
 
Back
Top