I have used the Parent-Child dimension on many tables within my db and it
works as desired. I do, however, have one set of tables that actually
reference each other and am wondering how, or if it's even possible, to set
up a parent-child relationship between two tables.

Here is how my table structure is:

Table1
Transaction_ID

Table2
In_Transaction_ID
Out_Transaction_ID

Both the In and OUT transaction ids in Table2 point to a specific
transaction_ID in Table1 but the in and out ids are not parent-child to each
other.

In other words, Table1.Transaction_ID -> Table2.In_Transaction_ID ->
Table2.Out_Transaction_ID -> Table1.Transaction_ID ->.....back to
Table2.In_Transaction_ID and so forth and so on...

I've done this in the past using a Stored Proc. and nested sets. Is there a
way to do this in AS?

TIA
Cary LaPora
Database Administrator
The Lancair Company
CaryL (AT) Lancair (DOT) com

Have you tried to bring the query together in a view and build your dimension
form the view?