AnsweredAssumed Answered

Can I convert multiple fields into one?

Question asked by leonhart1981_1 on May 21, 2014
Latest reply on May 23, 2014 by philmodjunk

Title

Can I convert multiple fields into one?

Post

     Below screenshot is the source that I am about to import. 

     The column F ~ J indicated what types of shipment were made with a letter V.

     My question is that can I somehow convert these five fields into one draw-down field after importing?

     So on FileMakePro database will only have a field called "shipment type" which contains a draw-down menu with the choices of air shipment, ocean shipment, FedEx, UPS, and Post? 

S3.png

Outcomes