How to Reverse Linking between 2 tables ?
Hi,
Is it possible to change "Link to" to "Link from" between 2 tables?
I happen to have 1 only contact record on a link to sub-menu, don't need more. Is it understandable?
Looking forward, being at your disposal.
Best regards,
3 replies
-
I read the question as asking if one can change a reference field from a "Link to" to a "Link from". If that is the question then it is no. You have to create a new field.
Then you have to either create a button with John's script or do a Update Multiple Records.
-
Hi Julien
The answer is yes, but only if you have, as you mention, a one to one relationship between your tables
for a in select Table1 do a.(Table2One := first(a.Table2Many)) endRegards John
-
Yes, Fred is right. I didn't explain my reply very well. My Table2One is a new reference field. Once updated the Table2Many reference field can be deleted if you are sure it has worked correctly.
Content aside
- Status Answered
- 2 yrs agoLast active
- 3Replies
- 39Views
-
3
Following