Automatically populate one field on change of another field?

[jbradley]

We an asset tracking have a program that uses an Access 2000 db as it's back end. Its help desk allows linking of tickets to computers by populating a field in the help desk table with the computer service tag. I would like to automatically populate a free field in the same table with the computer name from the computers table. Is there any way I can do this? I can modify the database but cannot change the program.

 

[dhookom]

Doesn't the computer service tag allow you to look up the computer name? Are you sure you need to store the computer name in more than one table?

Are you using a combo box to select the service tag? If so, does the Row Source table of the combo box include the computer name?

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]

 

[jbradley]

My boss wants the computer name in the help desk table so he can include it in his reports. The front end application is an external program, not an Access application, so I can't make changes to there. It's rather old so there is no support available. The flexibility of the reporting module is limited. I'm trying to make chicken salad here from less than ideal raw materials.

I'm thinking of something like a SQL trigger or some event that fires on a change of the service tag field but I have no familiarity with Access beyond tables and queries.

Can anyone point me in the right direction?

 

[dhookom]

There are no triggers in Access tables. If you can't change your front end, you might need to regularly run and update query.

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]