USe self-join to get many employees of same manage

[Anh_Tran]

Dear All,

I use a self -join of the same database to get many employees of the same manager but it gives me the same number of record of parents record, but I want to show the parent record (manager) only once . And also I would like to find the data in portals. If i use two separate database , it is ok but the same datatabse ., it gives me alot of problems

Any one have done that before or have an sample file?

Thanks

[jmkimmel]

Are you looking to show the manager and the people reporting to them on the same layout?

If so, you can use a portal based on a relationship set up between a Manager# field in the file self joined to the employee# (or whatever reference number you are using for each person.

This should show the manager as the parent record and unless the manager is notated as managing themself, it should not show the manager on the list of their employees. You could then count or summarize information in the portal using summary functions on the related field.

Did I address your question or did I misunderstand what you are asking?

[Anh_Tran]

Thanks jmkimmel

I got it.

Thanks