do i have to do something else the get the data retrieved and displayed?
I don't know about your specific issue with external data... but
let's assume you don't get this to work as desired. What then?
One thing Aware does well is that it easily allows you to show Parent/Child data on the same form when there's a relationship between them.
One thing Aware DOES NOT allow is to show Parent/Child data on the same form UNLESS there is an AWARE relationship (peer, ob) between them...
EVEN THOUGH there is a physical relationship (foreign keys in your case) in the data.
(that just means you can't use the easy "built-in" way to show data ON A SINGLE FORM from related tables)
So, instead of the easy way of just putting the relationship field on the form, and setting the grid properties, you'd have to use a VP Layout with multiple content panels.
From your Table1 Query, when clicking on a row, use a process to save the Table1.PriKey into a temp field in LIRU. Then display the new layout FROMVP. The 1st panel being a FORM for the parent, with a 2nd panel thats a Query... FIND Table2 where Table2.T1_pointer = LIRU.temp_T1
There may be other ways too. You were trying the simple way just to prove you could get to the external data. In my experience, external data opens up a can of worms (that may be too harsh) - but I think thats due to my lack of experience working with it.
