AnsweredAssumed Answered

Record Number reference

Question asked by BetoBoton on Aug 10, 2009
Latest reply on Aug 10, 2009 by BetoBoton


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.