Excel form -> FM Form design issue: Suggestions greatly appreciated.
I'm fairly new to FM, so I maybe asking a stupid question.
I currently use a form I made on Excel to create purchase orders for my company. I have recently realized the limitations of using an excel form to keep track and organizing of all the products of all the orders I have made, and therefore I am trying FM.
I am currently trying to re-create my purchase order onto FM but here is where I am stuck.
I have a table on the excel purchase order which can specifly; sizing (x-small - 3xl), waist size (28-42), cap size (7-8) Look at image attached.
So currently I will type an "A" if the product requires sizing X-Small - 3XL such as a t-shirt, and use "B" if it is a pant, etc etc.
I was wondering how I can re-create this on FM?