Sub Form?

[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,

 

[Jack Cowley]

tblCompany
CompanyID (PK and autonumber)
CompanyType
CompanyName
Address
...other fields...

tblContacts
ContactID (PK and autonumber)
CompanyID (FK and long integer)
LastName
FirstName
...other fields...

Make a form based on the Contacts table and make that a subform on the main form where the main form uses the Company table as the Record Source. Now you can select a company and add as many contacts as you like to the subform.

hth,
Jack

 

[ChrisDo11]

i'll give it a try... what does FK stand for?

thanks,

 

[Jack Cowley]

FK = Foreign Key. Link your tables on this field in the Relationship window.

Jack

 

[ChrisDo11]

thanks but i don't think this is what i'm looking for. i have a master list of 1000 contacts. i want to copy from this list to create a new list of only 20 of these contacts.

i have a form which consists of 2 subforms - the master contact list and the new list i want to create. i can copy and paste from one to the other, but i would like to be able to select from the master and hit a command button which will copy to the new form.

hope this clarifies...

 

[Jack Cowley]

Create an append query that is run when you double click on a field in your master list. You could do it with a command button as well.

I am not sure why you want to do this as it creates redundant information unless you plan on deleting the records from the main table. Still you have two tables when one would do. You can add a Yes/No field to your current table and check the fields of the 20 contacts that you want instead of moving them to a new table.

hth,
Jack

 

[ChrisDo11]

what criteria do i set so it only grabs the contact i double click?

 

[Jack Cowley]

Use the records ID....