I have two tables (T1,T2) I want to store three fields in T2 (F2.1, F2.2, F2.3)

I have multiple fileds in T1, but wish to do a comparison of data in two of these fields with two in T2, say F2.1 & F2.2, with the value of F2.3 being the result which is displayed in a field on T1. All the fields are 'text'

I was thinking of using a 'IF" statement or a 'CASE' statement, but I'm having problems in working out the correct syntax.

I'd appreciate any assistance, Thank you.

How are Tables 1 & 2 related? Do you have an example file?

I haven't related them. I'm looking for suggestions.

Basicly, T1 contains various data including two fields which when the data is selected from a value list (fixed number of choices), I wish to have a lookup peformed on another table (T2)to get the data for a third field (from T2) input automatically into a third field of T1.

I've tried to be generic in my problem, but can be more specific with an example if you prefer.

I thought that I would need to have a calculation field to do this & which has given me difficulty with the correct syntax. Perhaps this is not the best way to handle this problem. Your suggestions would be welcome.

You can email me direct on [email protected] if you need a sample file.

Thanks in anticipation

You'll need a relationship between the two tables if you want a field in table 1 to return the value of a field in table 2 (unless the field in table 2 is global).

Your best bet for getting help on these forums is to explain in more detail what it is you hope to achieve and posting your file right to the forums if you think that will clarify things. :

Thanks Kent,

I have uploaded the two tables to give you an idea of what I wish to achieve

Regards

Test.zip

Sorry scnook,

We're going to need to know a lot more than what you've shown us to figure out what you hope to achieve. :qwery: