Bring Records from an unrelated database into view 1

[arbusta]

My situation is very similar to those before but it needs a little tweaking!

Here is what's going on!

Table 1: tblFORM
LAST_NAME FAMILY_DB
SMITH PL582
ANDERSON PL695

Table 2: tblPL582
NAME AGE
JOHN 35
JENNY 33
MIKE 7

Table 3: tblPL695
NAME AGE
FRANK 35
MARY 33
SALLY 9

I need it look like this:

Smith
John
Jenny
Mike
Anderson
Frank
Mary
Sally

I have been playing with this one for two days now and I am back at square one. I have tried taking previous tips and modify them to my situation but nothing seems to work!

Any suggestions!!!

Thanks everyone!
Andria

 

[cmv131]

I am going to go out on a limb and say that this isn't possible with that table structure. To the best of my knowledge there is no way to relate a table name to a field value, which is what you would have to do to get the results to match.

Any idea why the database is setup this way, and any way you can change it to a more normalized setup?

Without something linking the tables, it isn't possible to group on anything, since there are no matches. I really believe you will beed a data structure change to be able to achieve the desired results

 

[arbusta]

That's what I thought! Thanks for the help!