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