Skip to main content
Question

Field Y to get copied on field X, just within the same record...

  • September 17, 2019
  • 0 replies
  • 13 views

I have 2 fields (X and Y) within the same table. 
If within a particular record, if Y is modified, I want X to get the same value. If Y is in record# 22 only, only this record's field X should be modified.

How to go about it?

------------------------------
Naveed Ahmed
------------------------------
This topic has been closed for replies.

  • Registered
  • September 17, 2019
Are you expecting field Y to be empty and then when it is filled in you want the data transferred over to x? Are you wanting X to be kind of like a logging field? As in it will hold all of the previous data that people enter into Y, could happen multiple times?

I'm just trying to figure out why you need the data duplicated to a secondary field. If the data is going to be the same between the fields then I don't see the use case. Maybe you can explain a little bit more about the use case.