Input boxes

  • Thread starter Thread starter Chris R
  • Start date Start date
C

Chris R

I am designing a DB that utilizes several smaller tables
(e.g. Buyer, Contact Name) The information in my main
table uses a lookup to get the info to prevent type-os.
However, when I use [Enter Buyer Name] in a query I get
an error that says that the query is too complicated.
But, if I use [Enter Style #] which is manually typed in,
I get what I want. Am I missing something about this?
It seems like I should be able to so this.

Also, I would like to utilize the Filter by Form function
to include variable criteria. Is there a simple way to
do this?

Thanks

Chris
personal email is fine, as long as it is related to this
subject. No SPAM please.
 
I am designing a DB that utilizes several smaller tables
(e.g. Buyer, Contact Name) The information in my main
table uses a lookup to get the info to prevent type-os.
Click to expand...

Check out the critique of "Lookup Fields" at
http://www.mvps.org/access/lookupfields.htm. Most developers avoid
using table datasheets for ANY purpose other than debugging; you'll do
much better to use a Form (with, by all means, a combo box "lookup" to
enter this data).
However, when I use [Enter Buyer Name] in a query I get
an error that says that the query is too complicated.
Click to expand...

Almost certainly you're searching using a buyer's name as a criterion,
but - concealed from your view by the stupid, misdesigned LOOKUP
wizard - what's actually in the table is a numeric ID. Create a Query
instead, based on a join *of the main table with the lookup table*;
apply the criterion to the BuyerName field from the Buyers table, not
to the ID in the main table.
Also, I would like to utilize the Filter by Form function
to include variable criteria. Is there a simple way to
do this?
Click to expand...

Could you give an example of what you mean by "variable criteria"?
 
Back
Top