Subject Data Integrity
Author Malcolm Smith
I have a small problem and am not sure if I should be making the change in
the DB (an issue outside of this list) or use one of the TIB_Query events.

I have a table which has two particular fields


I need to make sure that every record with the same IPADDRESS value has the
same LOCAL value. What's the best way to ensure the value of LOCAL during
data entry matches existing records with the same IPADDRESS. If it is the
first record with a unique IPADDRESS then LOCAL can be any value it likes.

Malcolm Smith
MJ Freelancing
ABN: 30 671 763 146