Hi all,
Apologies if I am asking for something already discussed, but I am going through posts for hours now and can’t find anything that will resolve my problem. I am working on a database where I have basically two tables:
a) Loss Events
b) Action plans
I want to have one to many relationship i.e. for every loss event I want to have one or more action plans. Obviously there are LossEventIDs and ActionPlansIDs and obviously the action plans table has a column with LossEventID. I also created a one to many relationship.
the problem
My database is built in a way that I can only add new action plans to events already saved on my data base. So I have a form that displays all the information about an event and I can navigate through all entries in events table. Now I want to add an action plan to a particular event. So I have a button, I click “add new action plan”, this bring me to “add new action plan” form. The add new action plan form has one field which I want to be automatically populated, this field is the ID of the loss event from which I navigated to this form.
In other words I want access to understand that since I navigated to the “add new action plan” form, from the event ID “1”, then the “event ID 1” field on the “add new action plan” form shall be prepopulated with value 1. And the action plan table shall be updated accordingly.
Anyone who faced that situation???
many thanks in advance,
Nikos