As a brief overview, I have two databases: one is 'products', the other is 'companies'. There's a many-to-many relationship using another database.

For one report, I need to have a sorted list of all companies with products in the products database's found set.

Possible solutions I can see include putting everything in a temporary database, or flagging all records in the companies database. But I feel like there should be an easier way...

Thanx alot

I have two databases: one is 'products', the other is 'companies'. There's a many-to-many relationship using another database.

What is this other database ?

Where do you want this report to display ?

If the Product db has a field for Company, you surely could list all companies from the current found set.

If you flag each record from the current found set in the Product db, and want to have this report display in the Company db, I think you will need a "go to related record" script.

Could you explain a bit more your situation ?