I’m fairly new to Access and I’ve encountered an issue I hope will be easy for one of you to tell me how to fix.
I use Access to help organize personal relationships for a large number of people. There are two tables at play here. The first table list information about specific individuals, one person per row, and the second table is intended to track the relationships of multiple individuals.
The individual table is
The Personal Relationship table is:
I also have a query created where it prompts me for a name, and then returns only the rows where that name is in either the person 1 or person 2 fields of the Personal Relationship table. The problem I’m having is that I can only get that query to work if the names in the Personal Relationship table are manually typed for each record, as opposed to limiting the Person entries to only those that are already entered on the Individual table. I can get the Personal Relationship table to only accept names already on the Individual table by means of a drop down menu (reminds me of data validation in Excel), but when I put in that restriction, the query no longer works. I’ve tried reusing old query’s as well as creating new query’s, and I just can’t get the query to return any results if I make it so that the Personal Relationships table is linked to the Individual table as it relates to the person column.
I hope this makes sense the way I have described it. Would one of you please tell me what I’m doing wrong that is preventing me from ensuring that a name can only be on the Personal Relationships table if it is first on the Individuals table, AND have a query that only returns the entries from the Personal Relationships table with the name I type in the pop up box that are in either the Person1 or Person 2 fields? I know how to get each of these things individually, but for some reason I can't figure out how to marry them together so I can have both.
Thanks for your time!
-Opie
Bookmarks