Adding values in fields to specific records

[seattleflo]

Hi,

I have attached the database that relates to my question.

I have 4 records. Each record has tabs (address, project/topic, publication, etc.) that correspond to applicable info for that record.

If you look at the Publication tab, you will see a drop-down field that uses a value list for selecting a publication title.

I would like to "apply" a publication field value to only a select set of records, rather than everyone in the database.

While looking at the Publication tab, notice the "Core Audience" radio buttons at the top of the database.

How can I select a specific publication value to be assigned to only a specific core audience?

For example, how can I select the publication "One Touch" and have it apply to any and all record(s) whose "Core Audience" matches "NCSRP?"

It was suggested that I can do this via a script, but I don't know how.

Thanks so much for anyone who can help.

Sincerely,

Seattleflo

Database.zip

Edited January 14, 2008 by Guest

[Breezer]

I assume this is something you will be doing frequently whenever there's a new publication or a new issue. If so, then a relational model would work best instead of the repeating fields. I will modify your file to see if it suits your needs.

Edited January 14, 2008 by Guest

[seattleflo]

THANKS SO MUCH!

[Breezer]

Sorry for the delay, but here it is.

Contact_Database.zip

[seattleflo]

Breezer,

You have been so helpful. Thank you. Thank you. Thank you.

(=

Edited January 15, 2008 by Guest

[Breezer]

You are most welcome.