Recent content by dzeglen

Hi, Thanks for the link. I can see that it's not necessary to create a separate table for some things, like categories or prefixes, correct? Also, I should integrate the personal information into my main contact table. However, I still require having many-to-many on both sides of my main...

Hi, Thanks for your response. I see what you're saying about creating a many to many relationship using a junction table so that each contactID can be related to one or more emailIDs. I do have a problem though, and its that my contactID is already loaded with two many to many relationships on...

Hello, I am managing a large database of contacts, and some have personal address information, multiple phone numbers, and multiple emails. I thought it would be best to put all this personal info into a separate table with multiple field names for email and phone (email1, email2, phone1...

Ah. Understood. I see how it works now. Very helpful. I haven't gotten to form design yet, but I understand that that is where I should be inputting data when I add new records. Thank you very much for your help, it is much appreciated!

Hi, Thanks for the prompt reply! I did what you suggested, which makes sense to me. However, when I open the contactsT page, and click on the plus sign beside the contactID, instead of seeing the events they've been a part of, it now asks me to "insert subdatasheet." Where do I go from here...

Hello, I am relatively new to Access, and I'm still working my way through understanding relationships. I was hoping someone could provide me with some advice. I work for an NGO, and I'm trying to build a database for all our contacts who come to our events. I've attached an image of the...