Forum Discussion

DonSloane's avatar
DonSloane
Qrew Trainee
7 years ago

Lookup list that does not include the current record

I have a table named 'Contacts'. I have another table named 'Services' with a one to many relationship between the two (one contact to many services). In the 'Services' table I have a field 'Referred ...
Formulas and functions
Relationships
AlexCertificati's avatar
AlexCertificati
Qrew Cadet
7 years ago
You'd probably be best served with another approach, for example you could use form rules to display a warning message to stop the user saving the Add Service form if Related Contact and Referred From are the same.