Hi to All,
I have a 2 different tables, 1 is "Projects" and the other one is "Client Details".
In the Projects table, i have added a lookup column for (Clients Details)Clients("cra1b_client").
In the app, i added a search box of a gallery with "Projects" data, the problem now, there's an error in gallery if i will include the search box and use the code below:
Search(Filter(Projects, 'Status (cra1b_status)' <> "New"),TextBox3.Value, "cra1b_client")
but if i will use this code, it will work fine:
Search(Filter(Projects, 'Status (cra1b_status)' <> "New"),TextBox3.Value, "cra1b_name")
the problem here, is "cra1b_name" is the automated unique number i also added in the column.
So i assume that i can only call the columns originally on the same table. Is there any work around to search the client instead?
