Prevent direct self-reference?
In a table that has a self referencing relationship, is there a way to prevent the user from selecting the same record as the child? e.g. in the classic User table example, where you can select a m...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI don't know why they block Record ID to be used in form rules.
but, no problem.
Make a new formula numeric field called [Record ID mirror] with a simple formula of [Record ID] and use it in the form rule. You may need to put the field on the form to get it to work.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
but, no problem.
Make a new formula numeric field called [Record ID mirror] with a simple formula of [Record ID] and use it in the form rule. You may need to put the field on the form to get it to work.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Oh, good plan. Thanks for that!
------------------------------
Chase Sterling
------------------------------ - Works perfectly, thanks again!
------------------------------
Chase Sterling
------------------------------
