I am using Access 2003. As I understand, there are things you can only do in the 'form' mode but not in the 'table'. Why is that? For example, let's suppose that I have the following fields in my table 'product': ID, Name, Code, Style
Every time I type a number in the 'Code' field, I would like the field 'Style' to receive a certain value. For example, if I type '1' in 'Code', I would like the 'Style' field to say 'Not available in Europe'. If I type '2', then 'Style' should say 'Shipping to Europe within 1 week', or something like that.
I know I can do that in the 'form' mode by including a procedure for the 'Code' field. But, what if I don't want to use the 'form' mode to type my data, but the 'table' mode? How can I do that in the 'table' mode?
I thank you in advance!