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!!
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๐
User | Count |
---|---|
18 | |
9 | |
8 | |
5 | |
5 |