Lookup values based on fields in table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RR - 27 Dec 2004 13:39 GMT

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.

Reply to this Message

Jack MacDonald - 27 Dec 2004 14:48 GMT

>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
[quoted text clipped - 7 lines]
>And I dont want to make a form for this data entry - just
>to do it in the table.

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Reply to this Message

John Vinson - 27 Dec 2004 17:04 GMT

>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]

Reply to this Message