input data in forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a form set up and I have 3 fields that are a lookup. When I look at
the table the 3 fields that are a lookup , the data is not there. . Can you
tell me if there is a way to put it in without doing a update query? Any
help will be appreciated.
thank you mac
 
Hello,
I have a form set up and I have 3 fields that are a lookup.
Click to expand...

Are these fields defined as "lookup" fields in your Table? or are you
using Combo Box controls ("lookups") on the Form in order to view and
enter data?
When I look at
the table the 3 fields that are a lookup , the data is not there. .
Click to expand...

What *is* there? Numbers? If so, the table is working exactly and
precisely as it's designed to do. Tables are NOT designed for viewing
or editing data; they're designed for efficiently storing data. My
guess is that your table is working just fine, storing the numeric
foreign keys to your lookup tables. If you open the table datasheet
(for debugging say) then that's what you'ld expect to see - numbers.

If you open your Form, you'll see the text in the combo boxes (and the
computer will see the numbers, and you'll both be happy).

If you create a Report, base it on a Query joining your table to the
three lookup tables. Select the lookup table text in order to put it
on your Report.


John W. Vinson[MVP]
 
Back
Top