Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return alternate value if VLookup can't find match | Excel Worksheet Functions | |||
Match / Index off two "keys" | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |