Referenced Tables Updating

i have 2 tables(Clients, and details_client) i use clients data to populate the Details_client table, but once the Details_client is populated, if i happen to update the clients data, they is no way of updating the corresponding row on the Details_client table.

Please Help!!

0 2 94
2 REPLIES 2

Details_Client should be a child table.  This is typically done by including a Ref column that holds a "pointer" (the row key) to the Clients table top the specific Clients row.  Maybe this column is named simply [Client].

For any data, that you are replicating from the Clients table into the Details_Client table, use a Virtual Column and assign it an expression similar to:

[Client].[Name]

...or...

[Client].[Phone]

 Any time the Client row is updated, all Details_Client rows using that Client as the parent will be updated automatically.

I hope this helps!

Kudos, This has been of grate help, Thanx alot๐Ÿ˜Š

Top Labels in this Space