Hi,
I'm stuck to find a solution on my calender form:
I have 4 tables:
I've made a form with al events from tbl event, and now i want to add a listbox for a couple of jobs where you can select a contact. The value of the event, job and contact is stored in the tbljobdetailsevents. So if I pick a name for the first job in the first event, it has to store the id of the event, job and name in the tbljobdetailsevents. For the second job it has to refer to another record in the tabel tblJobDetailsEvents (see picture)
Does anyone has suggestions how to implement this?
Thanks in advance
Steven
I'm stuck to find a solution on my calender form:
I have 4 tables:
- tblContacts
- tblEvents
- tblJob
- tblJobDetailsEvents
I've made a form with al events from tbl event, and now i want to add a listbox for a couple of jobs where you can select a contact. The value of the event, job and contact is stored in the tbljobdetailsevents. So if I pick a name for the first job in the first event, it has to store the id of the event, job and name in the tbljobdetailsevents. For the second job it has to refer to another record in the tabel tblJobDetailsEvents (see picture)
Does anyone has suggestions how to implement this?
Thanks in advance
Steven
