raydan
Registered User.
- Local time
- Today, 05:20
- Joined
- Aug 24, 2005
- Messages
- 28
Hi, all.
Im trying to show multi level organization with a query and im not sure how to do it. I have a table that is named Originators, that includes all of the persons personal info and this table gererates a OriginatorID. Next I have a table called OrgTree that has the fields as follows:
OriginatorID---Auto lookup to Originators---OriginatorID
LastName--Text
FirstName--Text
StartDate--Date/Time
UpLineOrigID--Autolookup to Originators-OriginatorID
UpLineLast---Text
UpLineFirst--- Text
This works so far, but I would like to see all the people brought in by originator (a) and all the people brougth in by those people and so on. I guess this would be a tree, but im not sure if thats my problem.... Can this be worked out with a query or do I need to do something else. God I hope it can be done with a query.
Thanks for any help.
Scott
Im trying to show multi level organization with a query and im not sure how to do it. I have a table that is named Originators, that includes all of the persons personal info and this table gererates a OriginatorID. Next I have a table called OrgTree that has the fields as follows:
OriginatorID---Auto lookup to Originators---OriginatorID
LastName--Text
FirstName--Text
StartDate--Date/Time
UpLineOrigID--Autolookup to Originators-OriginatorID
UpLineLast---Text
UpLineFirst--- Text
This works so far, but I would like to see all the people brought in by originator (a) and all the people brougth in by those people and so on. I guess this would be a tree, but im not sure if thats my problem.... Can this be worked out with a query or do I need to do something else. God I hope it can be done with a query.
Thanks for any help.
Scott