Frustrated Newbie - Lookup Question

[LMWilliams]

Hi
I am in the midst of creating a database. I have done my best to read these
posts and am sure my question has already been posed, but this is like a new
language to me so when the answer doesn't correspond to my information, I
must stop.
Here is my question: how can I get the lookup function to work in my
database? It kind of works in some fields, but then not in others. I seem to
have used lookup wizard in sokme paces and then figures out the code in
others. I know this can be done and I continue to feel less and less
intelligent as my time on this project progresses.
Please help.
Many thanks in advance,
Lucy

 

[Duane Hookom]

You should avoid all frustrations with lookup fields by never using them.
Consider reading http://www.mvps.org/access/lookupfields.htm.

 

[John Vinson]

Hi
I am in the midst of creating a database. I have done my best to read these
posts and am sure my question has already been posed, but this is like a new
language to me so when the answer doesn't correspond to my information, I
must stop.
Here is my question: how can I get the lookup function to work in my
database? It kind of works in some fields, but then not in others. I seem to
have used lookup wizard in sokme paces and then figures out the code in
others. I know this can be done and I continue to feel less and less
intelligent as my time on this project progresses.
Please help.
Many thanks in advance,
Lucy

The Lookup feature is of VERY limited utility, and often causes more
harm than good. Follow Duane's link for a critique.

I suspect the problem is that you're making the very common mistake of
trying to use Tables for data entry, editing, and viewing. That's not
their role: tables are repositories for data, NOT user interfaces to
data.

You can use a Form (with combo boxes, listboxes, search capabilities,
etc. etc.) as a frontend to the data which is stored in your tables.
You'ld only open the Table datasheet for debugging purposes.

John W. Vinson[MVP]