concatenate a lookup value

[southpawz505]

Hi all - I have a small problem I was hoping someone could help me with. I have a table with a bunch of columns (call it Table A), one of those columns being a look-up (foreign key) to another table (call it Table B). I would like to have another column in Table A that is a concatenation of the value in 1 column on Table A with the look-up value from Table B. What is happening though is a concatenation of the value from Table A and the KEY from Table B. I understand why it is doing this, I just am not aware of a way to get the concatenate to use the lookup value instead of the foreign key. Is this possible?

Thanks!

[JoeM]

From a relational database standpoint, you usually should not ever try to store a value in a table which can be calculated. All calculations should be done/returned in queries.

So why not just join your two tables in a query and do you calculation there via a Calculated field?