I wan't a field to show A,B orC based on other field values matching.

[BarnetBoy]

I have a problem. I am trying to get a field in a table to somehow automatically enter a value of either A, B or C. I want it to put in A if a value in another text field in the same table matches exactly the text value in the "A" field in another table. I want it to put in B if a value in another text field in the same table matches exactly the text value in the "B" field in another table. etc. The two tables are linked via a date field.

Help! Be gentle with me - I'm a novice.

Thanks in advance for any help you can give.

 

[neileg]

Normally you should not store a value that can be calculated when you need it. However, your mention of a date link suggests that the values may change over time, and that a calculation in the future may produce a different result.

I think the best way would be to use a combo box on a form to capture the user input. The combo should be based on a table that holds the allowable text values, and assigns these A, B, C etc. Use some code in the form to set the dependant field to pick up the value from the combo.
There are other ways you could do this.

I realise this is not a trivial suggestion for a newbie.