Reflexive Relationship
-
How can I create a Reflexive Relationship in MS Access not in MS access project. I got a document where I can create this relationship in MS access project.
My Blog:
http://dineshasanka.spaces.live.com/ -
From the dim dark annals of my brain, I think you need to add the table to the relationships page twice. Then you can link the relevant fields.
It's been ages since I've worked with Access, so that could be wrong
--------------------
Colt 45 - the original point and click interface
-
thankx for the update, I have done that way, But I think there should be another way of doing it
My Blog:
http://dineshasanka.spaces.live.com/ -
There is - use the SQL pane and write the query yourself. Is that what you mean?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
Currently in there is relationship pane in which you can't do this type of releationships
My Blog:
http://dineshasanka.spaces.live.com/ -
By "reflexive", do you mean a self-join? If so, I agree with Phill Cart's response - just add the table again and Access will create an alias for it.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply