AnsweredAssumed Answered

Record Number reference

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

Title

Record Number reference

Post

It may be a design flaw, but....

 

Case:

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.

 

Possible?

 

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.

 

Outcomes