Showing multiple columns in on drop down

[Fleet_Cruisin]

Hi 

I am creating an inventory app and I want to show product id  and associated image in one drop down box when creating the purchase order. The image is in another table. Also When I add purchase order through app i want to add only the product id and not the image which is showing in the dropdown.

Please help in this regards.

[WillowMobileSys]

Typically the Product would be listed in a Products table and the Purchase Orders would have a Product column defined as a Ref column to the that Products table.   The Product column in the PUrchase Order would then show a dropdown of available products from the Products table.

In this scenario, all you would need to do is set the Label property in the Products table to the column you want displayed and the image to go along with it.  This does require the image column to be available in the Products table.  It can be an assigned from some other source/table if that is what you have.  See image below.

This label combination is for display only.  The row key value (the row reference) is what will be saved into the data.

[Fleet_Cruisin]

Thank you for the support.. Its working now..