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,

- Fred
- 2 yrs ago
- Reported - view
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.
- John_Halls
- 2 yrs ago
- Reported - view
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)) end

Regards John
- John_Halls
- 2 yrs ago
- Reported - view
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