Record Number reference
It may be a design flaw, but....
2 tables Contacts and References where references is who referred the contact.
CONTACTS Contact::ID is related to REFERENCES Referee::ID
Contact::ID is indexed auto-numbered on creation
The fact is if I DELETE the contact in the CONTACTS Table, I have an Referee::ID number which doesn't match the proper Referee(deleted) correct?
I was trying to have a REFERENCES Referee::RecNumber field to solve this.
What is the proper way to do this?
It seems I'm chasing my own tail, with no tangent exit....
Any ideas would be welcomed.