Setting up Marketing table

[Guest]

I am a novice at Access - have Access 2003 - am trying to design a database
which can show the following
Table 1) Company Details
Table 2) Contact Details (1 Co - many contacts)
Table 3) Marketing Activities ( 1 contact - Many activities)

I have linked the 3 tables via 1) CompanyID (in Contact Table) 2) ContactID
(in Marketing Table).

I have set up Contact Form - with imbedded Marketing Table - which allows me
to update the marketing activities for each Contact individually - however,
what I need to do is be able to do an update query which allows me to select
Contacts (to a defined criteria) - & run a query which updates all the
selected records with a specific Marketing Program...which I just do not seem
to be able to do!!

I know that Access can do it - I had a database set up for me by an agency
years ago that did this - but just do not seem to be able to work out what it
is that I am doing wrong. HELP ANYONE??

 

[John W. Vinson]

I am a novice at Access - have Access 2003 - am trying to design a database
which can show the following
Table 1) Company Details
Table 2) Contact Details (1 Co - many contacts)
Table 3) Marketing Activities ( 1 contact - Many activities)

I have linked the 3 tables via 1) CompanyID (in Contact Table) 2) ContactID
(in Marketing Table).

I have set up Contact Form - with imbedded Marketing Table - which allows me
to update the marketing activities for each Contact individually - however,
what I need to do is be able to do an update query which allows me to select
Contacts (to a defined criteria) - & run a query which updates all the
selected records with a specific Marketing Program...which I just do not seem
to be able to do!!

I know that Access can do it - I had a database set up for me by an agency
years ago that did this - but just do not seem to be able to work out what it
is that I am doing wrong. HELP ANYONE??

What difficulty are you having? You don't describe the structure of your
tables so it is hard to be specific, but it sounds like you don't need to
*update* (existing) records; you instead need to add new records to the
Marketing Activities table for a group of contacts - an Append query, in other
words.

Create a query using the Contact Details table. Select whatever fields you
need as criteria to choose the desired contacts. In a vacant Field cell put
the value for the marketing program. Change the query to an Append query and
select the Marketing Activities table as the target; append the contactID from
Contacts to the ContactID in Activities, and the "calculated" field into the
activity.

John W. Vinson [MVP]

 

[Guest]

THANK YOU - using your guidance I was able to work it!!