Now, I want to use this as a foreign key source when adding or editing a record... however I want to use the data like this:
Code: Select all
SELECT tbl_item.item_id as iValue,
concat(tbl_item.itemnumber,"-",tbl_item.description) as description
order by tbl_item.itemnumber asc
Thus my array would be
for the entire table. Unfortunately, it does not seem that can base a foreign key field on this concatenated field..
I also tried using an enum field, and using the source as the database array, but every time I tried, it crashed.
Ideally the drop down result would be: