Combo Box

[chrisguk]

Hi,

Have two tables:

tblAccounts
pkAccountsID
fkNUmberID

tblNumber
pkNUmberID
NumberDetail

I have a form which had the tblaccounts created using the wizard. I then remove the fknumber field and replace it with a drop down combo box.

My question is! How do I lock the value selected in the combo box so that it cannot be used by another account?

 

[MarkK]

It seems to me that if a particular Number belongs excusively to an Account, then it should be a field in the Account table. Why is it necessary to link to a related table?

Just do this...

tAccount
AccountsID
NumberDetail