Hello everyone,
I have two tables which have a relationship one to one. The way I introduce data is from a form in which I click on a button and it transfers all the information to the table called "aa_DatosRecibidos". Everything work as intended.
But when I created a new form with both tables with this mechanism (with this button which is basically a DoCmd.TransferSpreadSheet), the second table called "aa_DatosProyecto" does not update correctly in the form.
I tried to do some tests. If I create a new form with both tables with their respectively field and introduce all the data manually it works (the "id_item" updates on both).
It seems like the "id_item" from "aa_DatosProyecto" does not recognize the relationship with the table 1 when both tables are in a form with this command button.
Could you help to solve this problem?
Thank you in advance,
Regards.