Query with linked tables returns blanks recordset

[mari_hitz]

Hi all,

Hope you are good. Please note that I have a database that has two tables with the same field, however, in one table I have the information being worked at the moment and on other table the information worked on the past months. There are cases that are being worked now that commenced in the past so they are on the other table for which I had already done an analysis.
I would like to bring the field that contains the analysis so I don't work on those cases again.
I think an update query would be good, however, when I design the query and add the two tables I link them by the field "ID" the analysis field appears in blank when there is information there.
I have "played" with the Joins options and none of them worked, however, when I do not link the two tables the analysis field returns the information but the ID's appear several times. Do you know how can I solve this?
Thanks!

 

[Ranman256]

Are the 2 tables related, parent/child?
Where the parent ID field is autoNum and the child table is long?

 

[mari_hitz]

Hi Ranman256!

Please note that the field is not autonumber. In both tables the field ID is number. The two tables are related by this field. Thanks!