How to use validation values stores in a second table?

[Andreas]

Hi all,

I would like to set a validation rule for a text field within a table.
The valid entries are stored in a second table and these values are
not the primary key in the second table.

What am I supposed to do in order to use the values in the second
table as a validation rule for the text field in the first table?

Can anyone help?

Best,
Andreas

 

[ruralguy via AccessMonster.com]

Since the possible values seem to be limited, have you tried using a ComboBox
for this field rather than a TextBox?

 

[Andreas]

Since the possible values seem to be limited, have you tried using a ComboBox
for this field rather than a TextBox?






--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20...

That worked. Thanks.

 

[ruralguy via AccessMonster.com]

Glad I could help.

Since the possible values seem to be limited, have you tried using a ComboBox
for this field rather than a TextBox?

[quoted text clipped - 18 lines]

http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20...

That worked. Thanks.