Linked table issue

[melaniecarr23]

We have a database that has a linked table from another database we are not allowed to make changes to.

This table includes a list of all our customers. Some are marked active, others inactive. I need to sort of add fields to the table (but can't because I can't modify the linked table structure) to have a newsletter field that is marked with a yes/no. This way, if a customer is marked active and yes, they would be exported to one newsletter list. If they were listed as in-active and yes, they would go on a different list. If a patient is listed as NO for the newsletter, they would not get any information whether they were active or not.

HOW can I do this without modifying the table structure?

Thanks,
Melanie

 

[dhookom]

Create a local table with the primary key value from the customers table for all the 'Active' customers.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]