Find Path between relationships

  • Thread starter Thread starter BAS
  • Start date Start date
B

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
 
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
Click to expand...

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]
 
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
 
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.
Click to expand...

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]
 
Back
Top