How I define a reflexive relationship in Access databases?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to define a reflexive relationship within a table, i.e. two fields
that relate together in the same table. I know it is possble to do such a
thing in Access projects but I do not know if Access data base offer the same
feature. I am currently using MS Access 2003 SP2. Thank you for your help.
 
I need to define a reflexive relationship within a table, i.e. two fields
that relate together in the same table. I know it is possble to do such a
thing in Access projects but I do not know if Access data base offer the same
feature. I am currently using MS Access 2003 SP2. Thank you for your help.
Click to expand...

Add the same table twice to the design surface - the second instance
will be denoted with the alias name table_1

Then simply draw the line between the fields of the two instances.

HTH
Ananda
 
an organization chart
a geneology
assemblies (e.g. components and subcomponents)
hierarchies
amongst others...
 
An Employee manages another Employee. It's also called a recursive
relationship. So employeeID is the primary key of Employee, but it's also a
foreign key in Employee, with the FK renamed to something like
managerEmployeeID.
 
Back
Top