I'm new to this forum. I'm wrestling with an FM-search issue that I am not able to solve on my own.
I have three separate databases where I have information about ports and port details. What I'm trying to do is to create an interface (an FM file) from which I can enter my queries,search the other databases and have the search results presented in one single page, possibly in one or two portals.
Unfortunately, I haven't found any way to do searches from one file into another. Regular portals will present matching records from other files into a portal. But those won't do as those matches are too strict - since they're based on a strict match between matching fields. My need is to be able to search not only for a strict match, but for a substring in a related field and have those result(s) presented through a common interface.
How should I go about to interface against those couple of databases?
Looking for your kind help.