[AccessD] Lookup Fields in Table Design

Gustav:
I understand your point.

When you drag a feild from the field list of a form onto the form Access
sets the row source type to table/query and creates the query definition for
row source based on the lookup property. True its not a defined query
available in the query defs collection, its stored in the controls
properties but it no longer is tied to the table's field lookup propertie.
At least in A97 it works this way.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Friday, March 26, 2004 12:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Lookup Fields in Table Design


Hi John

> I believe the discussion is: why not (use the lookups property)?

In that case I can't tell; I've just never felt the need as form
design for my part never is "very simple" and I always use queries as
recordsource for forms and combos. For me tables are tables.

However, if anyone find lookups in tables of value, feel free - but I
don't think I'll join the party. As I told, I've used them once (in
queries) only) - that's all.

/gustav

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com