Fetch Records to update dropdown box

Fetch Records to update dropdown box

Hi,

I am currently trying to put a FetchRecords script in whereby a dropdown is updated with data from another table. The syntax I have is as follows:

  1. get_available_products  =  Available_Products  [Product == input.Product];
  2. input.Unit_Trade = get_available_products.Unit_Trade;
  3. input.Unit_Cost = get_available_products.Unit_Cost;
  4. input.VAT_Class = get_available_products.VAT_Class;

The first two fields are normal single line fields and update fine. The VAT Class is a dropdown but does not seem to update.

I would be grateful for your asistance on this.

Thanks

Shaheed