Duplicate to a table

[Rick@]

Hello,

I have a form that includes a subform. I would feed the table my form data from my sub-formmulaire. This by selecting Code (IPC) for the "client" see attached demo file.

PS: The purpose of this "duplication" is because I need to keep (in time) on a table, the data in the other table are variables every month ...

Thank you in advance for your interest!

 

[PaulO]

So, in Table T_Master I can see that all that is currently recorded is the CIP you select from the drop-down field in F_Master, correct? Instead you want ALL fields in T_Master populated from F_Master, not just CIP?

I must say I'm a little confused as to what you're actually trying to achieve here, perhaps you can outline a little more as to what the Database is and what its objectives are?

 

[Rick@]

Hello PaulO,

Sorry for the delay "Vacation" ...

You understand. I want when selecting a CIP, all the fields in the transfer T_Master table.

The goal is a bit complicated to explain, in short it is to keep these data in statistical T_Master table because T_CIPNom table changes over time ...

Thank you!