5 Replies Latest reply on Feb 9, 2016 3:46 AM by beverly

    How do i turn multiple fields to one dropdown?


      Hi Guys,

      Im slowly learning FM14 and got so far upto now but am stuck at a point.

      I have attached my DB so far and also an image of what im trying to do and ill explain.

      If someone could either add a formula or tell me how to do it i would greatly appreciate it.


      From the example image what im trying to do is:

      When i add a new customer i input all their details in the customer page / tabs for each device.

      What i would like todo is after i have added the customer details goto the order page and create the order.

      I have worked out how to auto fill and get data from other db / tables etc but i would like when i add the customer details it then recodnises the customers devices and only show whats available in the device column and then breaks down from there until i choose the correct serial.

      So if customer bob had 1 Phone/Apple/Iphone/4s/sn 33293   and 1 laptop/acer/aspire/2232/sn23333  then when i click the device column line it only shows phone/laptop and drills down from there.


      I hope that makes sense and appreciate any help.