Recursive Relationships in Access 1

[parkers]

I've been struggling with this for a while. Can you define a recursive relationship in access (i.e. lookup a record in the same table). When you use the lookup wizard Access only displays the other tables.

any help would be appreciated

SP

 

[Golom]

Yes you can ... but you need to use two instances of the table. You can get a more detailed discussion of the issue (WARNING: MUCH more detailed) at this site.

http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html

 

[MichaelRed]

Golom,

Fantastic site. Worth a star for the mention / reference.



MichaelRed
m.red@att.net

Searching for employment in all the wrong places