Connecting Tech Pros Worldwide Help | Site Map

Lookups - What's Best...In a Table or on a Form?

  #1  
Old November 12th, 2005, 10:23 PM
Colin
Guest
 
Posts: n/a
Question#1:
Many of my forms have combo boxes (e.g. CustomerID). The combo box
looks up CustomerName from CustomerID in the Customer table. Am I
better off including CustomerName in my query (which the form depends
on)and have the combo box based on CustomerName or is it better to
limit the query fields by using just CustomerID? I'm guessing that
keeping queries to a minimum will impact the speed in which queries
take place.

Questions#2
Is it better to design the lookup on the form or originate it from the
table?

Thanks
  #2  
Old November 12th, 2005, 10:23 PM
Colin
Guest
 
Posts: n/a

re: Lookups - What's Best...In a Table or on a Form?


I think I can answer the second question. It appears to be better
originating lookups from the form.
As for the first question. The PK used as a combo box lookup works
fine for selecting a record but not changing one as you end up trying
to change the PK.


colin.m@sympatico.ca (Colin) wrote in message news:<658c1d2f.0404160910.21387664@posting.google. com>...[color=blue]
> Question#1:
> Many of my forms have combo boxes (e.g. CustomerID). The combo box
> looks up CustomerName from CustomerID in the Customer table. Am I
> better off including CustomerName in my query (which the form depends
> on)and have the combo box based on CustomerName or is it better to
> limit the query fields by using just CustomerID? I'm guessing that
> keeping queries to a minimum will impact the speed in which queries
> take place.
>
> Questions#2
> Is it better to design the lookup on the form or originate it from the
> table?
>
> Thanks[/color]
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Relationships, Lookups and Access 2007 tables netnewbie78@gmail.com answers 4 September 25th, 2008 08:05 PM
Need to change the table for bounded Forms !! agarwasa2008@gmail.com answers 5 July 2nd, 2008 07:55 PM
Alternative to lookups in tables - questions Russell answers 1 November 13th, 2005 02:30 PM
Using Lookups and Display in Forms Marc answers 2 November 12th, 2005 04:06 PM
Database Lookup Optimization and/or client-side validation alternative Eric Linders answers 2 July 20th, 2005 12:43 AM