I'm not sure if this is possible, but it would be great if it is.

I have 3 databases: projects, companies, people

i want to set up a search function within the project database that allows me to search for relevant companies. NOT companies that i've manually linked up with a project through primary/foreign key, but rather those companies that match certain criteria. I want to build something so that when i'm in a project record i can say "i'm looking for companies of this size from this country" and then those companies would show up in a portal.

is this possible?

thanks for your help.

Have you tried to create a file reference and then an all relationship (X instead of =, theres a name for it but I don't know what it is). Then you can do a find in the companies file and display it in the projects file.