Table: Data Type (Lookup)

Randomblink

The Irreverent Reverend
Local time
Today, 06:59
Joined
Jul 23, 2001
Messages
279
I came upon an idea, and wonder about it's feasability (sp?).

If I create a table...(let's say: tblEmployee)
I create a field in that table...(lets say: emPosition)
And I set that field's data-type to Lookup...
And I enter in 20 different entries as a Value List...

What if I want the users to enlarge the emPosition field...?

In other words...
What if next year we hire on 3 Elephant Trainers...
I want the user to enter 'Elephant Trainer' in the emPosition field...
THEN, I want the entry 'Elephant Trainer' to pop-up in that Value List...

How do I do this...?
If I create a form for entering new Employees...
How can I cause a NEW entry in the emPosition field to add to the list...?

Is there code? A shortcut...?
I DON'T want users to have access to my tables to go in and manually add it...I want to add it from the User Form...

How? How? How?

Thanks in advance
 

Users who are viewing this thread

Back
Top Bottom