I have a one normalized table (into two tables) and when I try to update the records of the table, only one table is begin updated, and the other table is also updated but is updated wrong, its supose to be no repeated record on second table normalized. i.e.
Denote that TablePriceType and see that doesn't have repeated records (because Table all only call the registry in order to save space And supose that I try to update a price H-M
and I put this statements
H-M price1= 888 price 2= 777
ok, really I have two tables and one query object(I have a mistake and call it tbltarifas instead qryTarifas), so when I update the two tables, i supose that query object can be also updated, but it doesnt.
and also put a repeated term in the table that contains tarifas.
could plz you or something send me a whatever example that use normalized tables and update this normalized tables with code?, Im really confused.