Multiple key access in Quick

Jeff Hoffman J.Hoffman@cchs.usyd.edu.au
Fri, 16 Jul 1999 08:52:24 +1000


At 10:33 am 15/07/99 PDT, you wrote:
>Is it possible to access a detail file by more that one key at a time?  Or
>do I have to create a new concatenated key of the two keys?
>
>Eg.
>
>FILE TRANS-DTL DESIGNER
>     ACCESS VIA KEY1,KEY2 USING FIELD1,FIELD2
>
>Or is below my only option
>
>FILE TRANS-DTL DESIGNER
>     ACCESS VIA KEY12 USING (FIELD1 + FIELD2)
>
>The later means database and data changes that I really don't want to do.

Santo

If you really do not want to make DB changes you could always create an
indexed  subfile with the concatenated key.

However I think John Pickering's suggestion would be more efficient.


+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
+ Jeff Hoffman                         + e-mail: J.Hoffman@cchs.usyd.EDU.AU +
+ Director                             +                                    +
+ WoniCon Pty Ltd                      +                           ,-_|\    +
+ 21 Prices Circuit                    +  voice: +61 2 9542 1527  /     \   +
+ Woronora    NSW     2141             +    fax: +61 2 9521 3979  \_,-._*   +
+ AUSTRALIA                            +                               v    +
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.