Lookup values based on fields in table

[RR]

I have a table where I want a field to have values from a
lookup table - but I would like to limit the list based on
the record I am filling in...

E.g. select from a "First Name" list based on sex - which
is stated in another field in the record I am entering.

Is that possible?

And I dont want to make a form for this data entry - just
to do it in the table.

 

[Jack MacDonald]

No

I have a table where I want a field to have values from a
lookup table - but I would like to limit the list based on
the record I am filling in...

E.g. select from a "First Name" list based on sex - which
is stated in another field in the record I am entering.

Is that possible?

And I dont want to make a form for this data entry - just
to do it in the table.

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[John Vinson]

And I dont want to make a form for this data entry - just
to do it in the table.

You can't. That's NOT what tables are designed to do; it's what forms
are designed to do.

As an analogy; suppose you were an Excel expert talking to a user who
said "I don't want to use formulas in my spreadsheets. I just want the
spreadsheet to have the actual values, I don't want them changing all
the time". They'd simply be wrong, would they not? Well, using table
datasheets for data entry and presentation is just as wrong.

John W. Vinson[MVP]