Access 2000 - Restrict User to key in certain fields

[sallypeh]

Hi, I would like to know how to do the following scenario in Access 2000.
Imagine I have a table, which has two fields X and Y.
User can only enter either field X or Y, but not both.
How to check the above case while user is real-time keying
in the fields of the table?

Thanks, Sally