Hello, I am trying to write a database for a company that I was just hired. I have a table that list information about different businesses, I have a table for email addresses since many of my businesses have multiple email address. I then have a table that allows me to check different ways organizations can help my company.
I have made a for and sub forms having them all linked together, that is finally working.
My question now is when I go to run queries I either get just part of the information or I get many duplicates of each record.
Can anyone point me in the write direction to figure this out. I don't want to start adding information till I know it works.
The other question is can I continue to add subforms to the database once I start adding information and the company is growing.
If I post my database can someone look at it and tell me what I am doing wrong. I have two drop down menu's. It will not let me use both dropdown menu's I really need to get this working. I am going to go ahead and post it. Any help will be appreciated.