I'm trying to create a query between two tables and I keep getting this error that 'one of the tables is not related to the other and that I need to edit the relationships. I checked the relationships and deleted them all to start from scratch. Same error. I'm using ssn as primary key, both tables have this. any idea what the problem is???
Sure do appreciate any help!
NEVER MIND, I GOT THAT ONE FIGURED OUT - HOWEVER<
New problem. I have a table with 1200 employees, another table with their dependents listed (over 2500 total). Both have insured SSN as primary key. I'd like to get these two merged and put together as a form which will show the one employee will all dependents on same screen. Now, in the table the dependents are listed by rows, not columns. What's the best way to do this
Sure do appreciate any help!
NEVER MIND, I GOT THAT ONE FIGURED OUT - HOWEVER<
New problem. I have a table with 1200 employees, another table with their dependents listed (over 2500 total). Both have insured SSN as primary key. I'd like to get these two merged and put together as a form which will show the one employee will all dependents on same screen. Now, in the table the dependents are listed by rows, not columns. What's the best way to do this
Last edited:
