C
Charles
Hello
I have a problem that is apparently simple but which I struggle to
solve. I have the following tables (simplified):
Table tblClient
Client_id
Client_name
Table tblContact
Contact_id
Contact_name
Contact_client
Table tblMeeting
Meeting_id
Meeting_client
Table tblAttendee
Attendee_id
Attendee_meeting
Attendee_contact
So basically I have contacts which are all linked (through a
relationship) to a specific client. I also have meetings links to a
specific client. And I have attendees, with a double link to
1) the contact
2) the meeting
so that I can have an unlimited number of attendees (contacts) from
the same client to one specific meeting.
I struggle to create a form that will allow to add these attendees to
a meeting. I have a form meeting, to which I have added a subform
attendees. The subform is linked to meeting through two links: the
meeting id and the client id.
The subform works absolutely fine to display data, but it doesn't seem
to work when I am trying to add another attendee, as access doesn't
seem to understand that the new attendee must match both the meeting
and the client id, and therefore does not automatically fills these
fields (it expects me to do it, and since I didn't create a text box
to do it, it is never filled). I could do it manually in the subform,
but is there a way to get access to automatically fill the new entries
in a subform based on the 2 ids of the form?
Thanks in advance
Charles
I have a problem that is apparently simple but which I struggle to
solve. I have the following tables (simplified):
Table tblClient
Client_id
Client_name
Table tblContact
Contact_id
Contact_name
Contact_client
Table tblMeeting
Meeting_id
Meeting_client
Table tblAttendee
Attendee_id
Attendee_meeting
Attendee_contact
So basically I have contacts which are all linked (through a
relationship) to a specific client. I also have meetings links to a
specific client. And I have attendees, with a double link to
1) the contact
2) the meeting
so that I can have an unlimited number of attendees (contacts) from
the same client to one specific meeting.
I struggle to create a form that will allow to add these attendees to
a meeting. I have a form meeting, to which I have added a subform
attendees. The subform is linked to meeting through two links: the
meeting id and the client id.
The subform works absolutely fine to display data, but it doesn't seem
to work when I am trying to add another attendee, as access doesn't
seem to understand that the new attendee must match both the meeting
and the client id, and therefore does not automatically fills these
fields (it expects me to do it, and since I didn't create a text box
to do it, it is never filled). I could do it manually in the subform,
but is there a way to get access to automatically fill the new entries
in a subform based on the 2 ids of the form?
Thanks in advance
Charles