I have a problem with searching
I have two tables with a link (a Master and a detail table)
Detail table is encrypted some fields.
The detail table shows a lookup wizard to shows the data from the master table (instead of the numbers)
In the form of the detail table i cannot get a search of any record writting the name of the Master table
Master Table
"Computers"
id_computer -> Int (KEY)
Computer -> Char
...........................
Detail Table
"License"
Id_License -> Int (KEY)
Id_Computer -> Int
name -> Char [Encrypted]
tecnico -> Char [Encrypted]
............................
Relation LINK
(MASTER) Computers.id_computer -> (DETAIL)License.Id_computer
............................
Fields are mark as Searchable
Search and filter settings
Searchable, Show on advanced search page and Include into all fields search are marked
I can search for a License name but not for the computer name
Even if i try to search directly for the Numer of id computer nothing is shown
In others tables that i have in my project works but detail tables are not encrypted... Could it be caused by this feature?
Anyone is having the same issue
Thxs in advance