hghbest Posted February 4, 2005 Share Posted February 4, 2005 I would like to know how to perform a find in an FM5 portal. When I try to do a find it returns all records. Thanks in advance! Michael Link to comment Share on other sites More sharing options...
FileMakin' Tom Posted February 4, 2005 Share Posted February 4, 2005 Perhaps there is a way - but I would simply switch to the file from wich the portal is derived and perform the find there. This can be done relatively seamlessly through scripting. Be well . . . Tom Link to comment Share on other sites More sharing options...
hghbest Posted February 4, 2005 Author Share Posted February 4, 2005 Hi Tom, You know that is what I would like to do but due to how the DB operates I really need to be able to do a find in the portal and return the found set. Any idea where I might locate this solution? I really appreciate your time. Michael Link to comment Share on other sites More sharing options...
Ender Posted February 4, 2005 Share Posted February 4, 2005 It sounds like you trying to find parent records that have one or more portal rows that match the criteria. A find like this should work if field types are right and the find criteria is entered correctly. Also note that finding in more than one related field does not produce the AND results you normally see for one request. Can you be more specific about how the relationship is defined, what the find criteria is, and the field types of the fields being searched? Link to comment Share on other sites More sharing options...
hghbest Posted February 4, 2005 Author Share Posted February 4, 2005 Actually it's a petty simple portal. The parent records only have three fields. In my main DB I have a portal that displays those three fields and lists 8 records. All I want to do is enter a find criteria in the first field and have all the records in the parent DB displayed in the portal. Does that make any sense? Link to comment Share on other sites More sharing options...
Ender Posted February 4, 2005 Share Posted February 4, 2005 Sorry, It may be my cold, but your description has only added to my confusion. Is this a self-join relationship? What are the entities and fields? Link to comment Share on other sites More sharing options...
hghbest Posted February 4, 2005 Author Share Posted February 4, 2005 No, it's not your cold. It's my lack of knowledge about FM! File DB contains... 1st entry - description 2nd entry - explanation 3rd entry - creation date There are no relationships, my portal in my main DB shows the files from my file DB. I'm trying to not leave the main DB and perform a find within the portal of the file DB. Make any more sense or should I bang my head on the wall a couple of more times to try and clear up my explanations? Link to comment Share on other sites More sharing options...
-Queue- Posted February 4, 2005 Share Posted February 4, 2005 There are no relationships, yet you have a portal? How the heck did you pull that one off? Link to comment Share on other sites More sharing options...
hghbest Posted February 4, 2005 Author Share Posted February 4, 2005 It was easy... I'm stupid! Actually, I do have a relationship - serial# to serial# Link to comment Share on other sites More sharing options...
Ender Posted February 5, 2005 Share Posted February 5, 2005 [ QUOTE ] Actually, I do have a relationship - serial# to serial# [/ QUOTE ] Hmm, you sure about that? If the serial numbers are unique, and the file is relating to itself (self-join,) then you would only see one record in the portal--the same record as you are on. I'm afraid this guessing game isn't going to solve your problem. If possible, why don't you try posting a zipped clone of the file. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.