Pulling data from one tbl to select from another? Creating a Qry for this...

[d9pierce1]

DBMeProfile - Copy.zip

Hello All,


I need some assistance on a Qry and a Frm relating to company Divisions. Attached is a db in progress...please be patient...
I have had to remove a lot of data from CSZ and ZipCode tables to get this small enough to send over


On the CompanyProfileFrm (Which will open up on dbOpen) I have a list box with attached form to choose Company Divisions. This works well....


If you clk on Contacts button it will open up company contacts where i have a list box of Divisions with a manage divisions button that will open up form.


What i am trying to do is create a Qry, Called ContactDivisionQry which will allow me to add Company Divisions to the form ContactDivisionFrm from that list
of chosen Company Divisions from the Company Profile Frm....


Example:
My Company has 8 divisions and I work for 2 of them lets say. I want to pick from the Company Divisions that are only related to that company.


I worked all weekend trying to get that to work and have had no success to it at all. It is some what complicated as there are One to Many and Many to Many tbls involved.


Thanks for all your assistance!


Dave

[Gicu]

Please have a look at the updated file. I have changed quite a bit of your forms/code to make it work,
please ask if you need more info.

Cheers,

[d9pierce1]

Hi all,
Sorry but it finally hit me what i was doing wrong! I got it fixed
Thanks
Dave