Allow Add for Database View as Lookup Table (v2021)

FedeLopez · Post by **FedeLopez** » Tue Mar 05, 2024 1:12 am

Hi all, I have a project that use a View as Lookup Table... then finally get item_id...
That works fine, and allow me to change how data is displayed and sorted in lookup...
But then, I can't use "allow add", except that I could change the url fram lookupviewadd to lookup tableadd...

There is any way to do that?

arbei · Post by **arbei** » Tue Mar 05, 2024 10:42 am

You may set the update table for the view by Table_Load server event. (v2024) Search "UpdateTable" in this forum.

FedeLopez · Post by **FedeLopez** » Wed Mar 06, 2024 9:16 pm

It is a phpm 2021 project, because is for PHP 7.4 version.
There is any way to work around that in phpm 2021?

arbei · Post by **arbei** » Thu Mar 07, 2024 9:59 am

You may try other available server events.

FedeLopez · Post by **FedeLopez** » Thu Mar 07, 2024 9:30 pm

Ok, this is what I finally did...
Added Custom Field in Lookup Table "Concat(field1,field2,field3)"
Then in Lookup setup I used same table, id as link, but this Custom Field as Detail field...
Using Modal for lookup any part of field 1 2 or 3 in any order works to find the record, if not exists Allow Add will work firectly with the table.
So there is no need to use the view