Data Entry using Auto Lookup query & Data Entry Form

[Bob N]

I am using Access 2003

Whe using the form all the information is filled in as expected. Then when
I go to the table, the added records are there, however the looked up
information is not filled in. The addition fields information that I enter
is filled in.

I then reopened the form, and all the looked up info, and the entries I made
are still shown there.

My question is; How do I get the looked up information added to the table.

Thanks for any help you can give me

 

[Jeff Boyce]

Bob

We don't know a thing about your underlying table structure, and "how"
depends on "what". What data are you trying to store in your table.

If you mean the "looked up information" is not being stored, but something
(?a number) IS being stored, this is exactly how a well-normalized
relational database table should be set up. Your table doesn't need to
duplicate the looked-up value, it just needs to know where to find it (in
the other table).

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bob N]

Thanks for taking the time to answer. The truth is; I am very new to access.
I was thinking that the look up information would be add into my table along
with the information I enter via the key board. Are you saying that the data
entry form using the Auto Lookup Query is not intended to add the lookup
infomation to the database.

Thanks



Bob

 

[Jeff Boyce]

Bob

Access is a relational database. Among other things, this means you DON'T
have to store the same text string (?your "lookup information"?) over and
over again when you can store the rowID of that information (hence,
"relational").

It's difficult to envision what you're working with (i.e., the subject
matter, topic, "domain") without some examples...

Regards

Jeff Boyce
Microsoft Office/Access MVP