Hello,
I am still in the learning phase of Access but I am designing a classification program for my correctional facility that I work for. I want to basically retrieve information from another table on a form. On my form I have selected my Record Source from a table I called "ReClassification. That table stores my questionnaire answers. My other table called "ActiveUsers" stores all the user information of the people.
When I open up the form, I want to be able to link their files accordingly from ReClassification Table to ActiveUsers Table. I have tried to research about Table Relationships, but have not been found any good examples.
So if I opened up "John Smith", The data from ActiveUsers personal information will show up, but I the rest of the fields to be blank for me to fill out. Then storing all that information into Reclassifcation.
I'm sorry if this sounds confusing, I am trying to explain the best I can.
Thanks in advance!
I am still in the learning phase of Access but I am designing a classification program for my correctional facility that I work for. I want to basically retrieve information from another table on a form. On my form I have selected my Record Source from a table I called "ReClassification. That table stores my questionnaire answers. My other table called "ActiveUsers" stores all the user information of the people.
When I open up the form, I want to be able to link their files accordingly from ReClassification Table to ActiveUsers Table. I have tried to research about Table Relationships, but have not been found any good examples.
So if I opened up "John Smith", The data from ActiveUsers personal information will show up, but I the rest of the fields to be blank for me to fill out. Then storing all that information into Reclassifcation.
I'm sorry if this sounds confusing, I am trying to explain the best I can.
Thanks in advance!