P
Patti
I read a discussion thread yesterday and don't remember
which one it was and can't find it now, but it referred
the sender to an article about The Evils of Lookup Fields
in Tables.( I printed the artice but don't remember the
HTML site I found it on.) Some of the information in the
article was not clear to me and so I have a few questions:
What I understood from the article was that is was better
to set the lookup fields on the form via list boxes or
combo boxes rather than in the table structure. Is that
correct and, if so, why? And my next question is, if we
are discouraged from setting up the lookup fields during
the table structure, why is that option even available?
The example the article used was company names field. It
said that "Any query that used that lookup field to sort
by that company name won't work. Nor will a query that
uses a company name in that field as a criteria...."
I have not found that to be a problem.
I am just in the process of beginning a large database
project and have set some Lookups via the table
structure. I want to fix it now before it gets too
complex.
Any thoughts on this???
Thanks, Patti
which one it was and can't find it now, but it referred
the sender to an article about The Evils of Lookup Fields
in Tables.( I printed the artice but don't remember the
HTML site I found it on.) Some of the information in the
article was not clear to me and so I have a few questions:
What I understood from the article was that is was better
to set the lookup fields on the form via list boxes or
combo boxes rather than in the table structure. Is that
correct and, if so, why? And my next question is, if we
are discouraged from setting up the lookup fields during
the table structure, why is that option even available?
The example the article used was company names field. It
said that "Any query that used that lookup field to sort
by that company name won't work. Nor will a query that
uses a company name in that field as a criteria...."
I have not found that to be a problem.
I am just in the process of beginning a large database
project and have set some Lookups via the table
structure. I want to fix it now before it gets too
complex.
Any thoughts on this???
Thanks, Patti