I Think I already have part of it

[Lou_Reed]

I have attached a db file and a capture.png file. The db is my database as it currently stands. The picture is of the relationships table.

Now close examination of the png file will reveal something. The previous post introduced to me junction tables - a very handy tool.

Now if you look at the png file you will see that unbeknownst to me two days ago I introduced the a junction table except that I called it the tblAttendance. It has all the characteristics of a junction for tblMeetings and tblPersonnel. I do have two employees and several meetings and their dates.

However, what must I do now to get these to show up in form frmEmail in their respective slots? As you can see I have a textbox for ysnMeetingID and a textbox for MeetingDate. I am have one for PersonnelID, ysnMeeting_Invite_Sent, etc..

I guess I learned something by tripping over it.

However, it must be connected to the frmEmail and their respective textboxes. How should I do that? I know the buttons to click, I just do not know the structure.

Any help appreciated. Thanks in advance.




Respectfully,

Lou Reed

[Bkper087]

I have not downloaded your database and I'm not sure if this is exactly what your looking to do, but you may look into the DLookup function.

[Lou_Reed]

i appreciated your response, but I do not understand. Could you elaborate on it. I did nit think of this option and it looks promising, but I am still in the dark.

Respectfully,

Lou Reed