Recent content by IDOL

If I wanted to run a search for a particular branch (bring up all the information - including.. Manager.. Employee etc) how would I go about it? As the information will bein different tables. The code:---------------------------------------------------------- Private Sub cmdSearch_Click()...

hhmmmm... I'll have a go. Not done much of Access since college :S Cheers for the advice.

I see what you mean. I just didn't want to confuse things. Having a separate table for employees would clearly distinguish between the Management. How were you thinking exactly?

That’s absolutely brilliant!! Cheers mate, well appreciated.

I am currently disigning a database. I have the following tables: tblManager:- ManagerID CompanyID First Name Surname Email tblCompany:- CompanyID Company Region Address_1 Address_2 Address_3 Address_4 Postal Code Tel No. Fax No. Email ManagerID Extensions Ad Tel No_1 Ad Tel No_2 Ad Tel...