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

 

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

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20...

That worked. Thanks.