form with drop down from linked table - not updating master table?

[ferd]

I have a database with 2 tables - basically one with data, and a
small lookup table called "location"

I built a form for input, and for the "location" field, it uses the
location table as a drop down data source. The form's been used and
data has been input.

As I browse through all the records in the form there's data and a
location for every record -
but when I look at the data table itself, the location field is empty -
every
single one of them is empty! where is that data being stored and how
do I get it out, for example in a query? since - if I do

"select * from data"

- the location field is empty... but again... looking though the all
the records
from the form view - there IS data there.

how does that work?

anyone have any ideas? am I looking at this the wrong way?

tia!
ferd

 

[Guest]

It would appear, based on your description, that the location field in the
data table is not bound to the combo box on your form.