[AccessD] Framework Discussion - set up question

1. First off I only would use this with related fields so the lookup (combo)
would always be based on a query with the key field hidden. CMIIW but lookup
properties don't change the query speed unless you weren't planning on
displaying the intelligible data in the first place. The query is based on
the table's data, ie. the key, it just display the text data as if you add
that field to the query - which would normally be done anyway. Who queries
to display the keyID field (unless its a subquery)?

2. I agree, this can be an issue.

score: nay-sayers 2 / sayers 7.5


DWUTKA at marlow.com said the following on 3/25/2004 11:53 AM:

>What's impractical about Lookup stuff in a table design?
>
>
1) When you query the table you're querying against some text... instead
of ID's... while there is no one right way.. you're adding confusion.

2) when you want to add additonal columns so that the sub table can have
it's own set of attributes because the system has "grown" you'll need to
revisit the table to make the changes for the FE, but if you're using
some sort of BE/FE setup then you can't do anything until all the users
are out :)


--
-Francisco