I am playing around with Access 2003 and am in the process of creating forms right now. I am running into issues with the following forms/tables:
Contact (ContactID, FullNameID, Title, Company, PhoneID, AddressID, EmailID, Webpage, Notes)
FullName (FullNameID, PrefixID, First, Middle, Last, SuffixID)
I have already created the tables and the forms for each item. I have set up the forms so that when a user is in the Contact Form and clicks on the FullNameID attribute, the FullName form opens.
What I would like to have happen now is after the FullName form is filled out and closed, the FullNameID attribute in the contact form populates (or concatinates) the information from the FullName form.
If you know how make this happen, please help me out.
P.S. I got the idea from the MS Outlook contact form. I'm simply experimenting and trying to duplicate the functionality to get a better understanding of Access and databases overall.