Find Path between relationships

[BAS]

I've a table many/many with ID fields
How I can do a query to find the path between two ID fields. I need know the
ID's relationships between them.

Thanks
Luca

 

[John Vinson]

I've a table many/many with ID fields
How I can do a query to find the path between two ID fields. I need know the
ID's relationships between them.

Thanks
Luca

I'm sorry, Luca, I have no idea what you're asking. What are the
structures of the three tables (the two "one" sides and the resolver
table)? What do you mean by "the path between"? Could you post an
example?

John W. Vinson[MVP]

 

[BAS]

Hello
Find Path: Take any two entities and find the path (all the links and linked
entities) between them.

The way to arrive from A to B through of its relationships.

Sorry for my english.

Thanks

Luca

 

[John Vinson]

Hello
Find Path: Take any two entities and find the path (all the links and linked
entities) between them.

The way to arrive from A to B through of its relationships.

Sorry for my english.

I *guess* that you can simply create a Query; add table A, table AtoB,
and table B. Join A to AtoB by A's primary key linked to the
corresponding foreign key, then join AtoB to B in the same manner.

Open the query as a datasheet by clicking the datasheet icon at the
left end of the toolbar.

John W. Vinson[MVP]

 

[BAS]

I have found a solution in this web http://www.dbazine.com/tropashko4.shtml

Thanks