Question

[ChrisDo11]

I have a master table which includes the following;

Company Type
Company Name
Phone
Fax
Email
Contact

When i start a new project i want to be able to make a contact list(table) using the above master table. I want to have a form which displays the mast table company name and contact. Then the user can highlight a company name and hit an "Add to List" button which will then add this company into a new table. Once the user has added all the contacts he/she needs they exit and have created a new table containing on contacts which will be related to that project.

I am not an Access person and only fumble my way through, but can Access do anything like this?

Thanks,

 

[WayneRyan]

Chris,

Sure Access can do that.

I think what you need is:

tblCompany:
As defined in your first post.

tblProjects:
ProjectName
ProjectStartDate
ProjectEndDate
ProjectManager
etc...

tblProjectContacts:
ProjectName
CompanyName

Then with an appropriate form you can view/maintain
all of your projects and manage your contacts.

Wayne