autolookup

  • Thread starter Thread starter gerald
  • Start date Start date
G

gerald

i was wandering if anyone had used the autolookup utility
much in access.im looking to use it at present, and all i
want is to type in a customers name and have his relevant
details appear below.i have two tables and i was wandering
does the relationships have a big bearing here. i have
done a bit of it so far, and then got to the stage where
im meant to create a select query for the two tables on a
1-many basis.i have selected the relevant fields from each
of the tables and clicked them in the query design grid,
but when i go to run it, i get an error saying type
mismatch. if anyone could help, that would be great.
thanks!
 
i was wandering if anyone had used the autolookup utility
much in access.im looking to use it at present, and all i
want is to type in a customers name and have his relevant
details appear below.i have two tables and i was wandering
does the relationships have a big bearing here. i have
done a bit of it so far, and then got to the stage where
im meant to create a select query for the two tables on a
1-many basis.i have selected the relevant fields from each
of the tables and clicked them in the query design grid,
but when i go to run it, i get an error saying type
mismatch. if anyone could help, that would be great.
thanks!
Click to expand...

The simplest way to do this is to create a Form displaying the data
that you want to see; use the Combo Box Wizard to create a combo box
on the form, using the option "find a record".

The type mismatch may be because you have fallen victim to Microsoft's
misdesigned, misleading, obnoxious so-called "Lookup" wizard. This
often causes such errors because what you *see* is the looked-up text;
what's actually stored in the table is a numeric ID, but that's
concealed from your view. Perhaps you could post the SQL of the query.
 
Back
Top