Conflicting FieldName captions in related tables

[evalesthy]

I have two related tables where the original designer assigned the same FieldName caption two fields in related tables. Hence, in table OrderHeader there is a field with a caption 'Name' and in table OrderDetail there is a different field with a caption 'Name'. My problem is that I am joining the two tables in a query and then I want to refer to the query values in a recordset. I cannot change (not my database) the table captions and table captions override any FieldNames you try to create in query view. So, in my recordset when I refer to rst.fields("Name&quot it does not know which 'Name' column I am refering to in the query. All other references to other rst.fields("&quot values work so the 'Name' duplication is clearly the problem. Any way to identify the correct query column in rst? Any other work around?

 

[lespaul]

What if you tried something like this:

SELECT OrderDetail.Name As ODName, OrderHeader.Name as OHName etc...

then in your recordset you should have the fields ODName and OHName and be able to tell them apart.

Good luck

Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned