Hi
I am working on a new access system at work (my first project of this kind), and would like to make a query that acts a bit like a trigger.
I have a main table called activities which holds data about departmental activities. When our company makes a deal, a press release is sent out.
I have a form each for deals and press releases. One of the combo boxes on the press releases form looks up a list of distinct deal names that are already in the system, so that the user can select the deal related to the press release that they are recording.
What I would like to happen, is that once this field has a value set, a query would pick up some other fields from the related deal and enter them on the press release form. If this field is not set, the user will be able to enter their own values in the fields on the press release form.
Could anyone point me in the right direction to do this? I realise that this may be a particularly simple question for some of you, but this is my first access db!
Thanks a lot
G
I am working on a new access system at work (my first project of this kind), and would like to make a query that acts a bit like a trigger.
I have a main table called activities which holds data about departmental activities. When our company makes a deal, a press release is sent out.
I have a form each for deals and press releases. One of the combo boxes on the press releases form looks up a list of distinct deal names that are already in the system, so that the user can select the deal related to the press release that they are recording.
What I would like to happen, is that once this field has a value set, a query would pick up some other fields from the related deal and enter them on the press release form. If this field is not set, the user will be able to enter their own values in the fields on the press release form.
Could anyone point me in the right direction to do this? I realise that this may be a particularly simple question for some of you, but this is my first access db!
Thanks a lot
G
