Restricting field entry

[Ibnul Ahsan Mayukh]

In a table I have 3columns with the primary key of MemberID. Of the columns in question, one is StudentID and the other is StaffID. What i want to do is that if a use enters the information in MemberID, he will not be able to input in the field in StaffID and vice versa. Can this be done? If so, how?
Thanks in advance.

 

[jdraw]

Don't let users interact directly with tables. Always use forms. Use some vba to validate user data entry according to the rules you set up.

 

[R. Hicks]

You can easily control this at Form level .. but not at Table level.

R.

 

[Ibnul Ahsan Mayukh]

Well, how do i that on a form level. any help at all is appreciated as i am a complete novice.

 

[jdraw]

There are a number of free videos on youtube.
Here's a complete introduction set by 599cd