I have layou that have a table with a set of records that inside have portals. There is a way that i can use the find in user interface to find a specifc record or records that have a specific record inside the portal?
If I understand you correctly, then yes, you simply enter find mode and type your find criteria in the portal.
Much depends on the results that you want. Say that you have a layout based on a table of clients with a portal to a Related table of invoices.
If you enter Find Mode and specify search criteria in the portal row, you will get a found set of client records that have at least one invoice matching your criteria. All related invoices then appear in your portal whether they match the search criteria or not.
So if you are searching for client records, that does what you need, but if you only want to see invoice records matching your search criteria, you might be better off searching on a layout based on the portal’s table (invoices in this example) instead.
Now I realize that in the find mode the filtered list that is used to show a specific set of records in the field inside the portal to select it is the problem.
When in find mode the list doesn't work, and I need the list to show the set filtered of records to do the filter.
See the picture of the layout.
The structure of the list is:
And the main layout is "CARDAPIOS", the portals inside the "CARDAPIOS". is "FT CARDAPIOS", and I use the field in the table "FICHAS TECNICAS 3 -> grupo" to do the filtering.
But in the find mode doesn't work. I get the error in the first picture.
In the browse mode works fine.
In find mode, all fields except globals are empty except for the search criteria that you enter. Thus, there is nothing to filter in a portal.
Why would that be a problem?
the FM does not allow me to type in the field. I don't know if is because is a drop down list field, or what.
That is an issue that has nothing to do with portal filters.
I would guess that this is a pop up menu rather than a drop down list as you can type text into a drop down list even if in find mode. Do you want the value list to work? Simple conditional value lists will work in find mode, but you have to enter the needed value into any match fields on the layout side of the relationship. If your layout is based on Cardapios and the portal on FT Cardapios, then the fact that your portal fields are empty will probably keep this particular conditional value list from working.
If you want to type search criteria directly into the field while in find mode and don't want to change the field format from pop up menu to drop down list, you could put an edit box copy of this into the portal row on top of or beneath the original. Then use Hide Object When with the Get ( WindowMode ) function to hide the value list formatted copy when in find mode and hide the edit box copy when in Browse mode.
An alternative approach is to enter the criteria into a global field while in Browse mode, then use a script to perform the find by entering find mode and using set field to transfer the criteria from the global field to the portal row field after entering find mode.
Retrieving data ...