DWUTKA at marlow.com
DWUTKA at marlow.com
Thu Mar 25 13:58:36 CST 2004
I don't get that 'main' argument. How could you NOT know that they are there? Granted, if I looked at a table, and saw that for Customer, it had a first name, instead of a CustomerID number, that I might be a little suspicious. However, entering that field, in the table, would show that it's a combo box, thus a lookup field, and I would know what is ACTUALLY stored within that field is a Long Integer foriegn key. (Or should be....LOL). Lookups are just part of Access' table design, and are relatively irrelevant when you use Access strictly as a BE. It's just like opening a table in datasheet view, and widening a column. It doesn't change the field size for that field, it just changes what you see when you are in datasheet view. Access remembers that too. (Still like to know WHERE it remembers it) But is that going to affect anything using that .mdb as a BE? No. I would really like to hear a solid reason for not using this. I'm definitely in the 'Use Lookup' camp otherwise. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins Sent: Thursday, March 25, 2004 12:54 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Framework Discussion - set up question What else in wrong with it? =============The main argument I was once given was that if you don't know they're there, you can make development errors. Well, if you don't know they're there, perhaps you shouldn't be developing in that particular database??????????? ;) The main advantage is to the user that wants to use lists but just doesn't have the expertise to do so. The table's lookup field is inherited by bound controls, which makes it an efficient solution for the user. Susan H. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com