If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup values based on fields in table
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. |
#2
|
|||
|
|||
No
On Mon, 27 Dec 2004 05:39:17 -0800, "RR" wrote: 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. ********************** remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security |
#3
|
|||
|
|||
On Mon, 27 Dec 2004 05:39:17 -0800, "RR"
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get data from combo box to popluate the next box | Lin Light | Using Forms | 4 | December 30th, 2004 05:01 PM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
STORE multiple values from a lookup table | beller | Database Design | 2 | June 16th, 2004 04:16 AM |