two alternate match keys
 

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

two alternate match keys
 

On Wed, 27 Dec 2006 13:46:01 -0800, FilemakerPro_Developer
wrote:

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

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


---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *