I have just starting using Creator and learning its features. I have a single Excel sheet with many columns, that I have imported into Creator. In one of the early attempts, one of the columns was imported as "Drop Down". This is close to what I want to do (forcing users to use correct and full customer names - rather than the free for all data entry that was happening in Excel). What I actually want to do, is to end up having that 'column' of data split out as a separate form - to be used as a lookup table in a Drop Down field (Some my users can only select from the standardise list of customer names). I want this a seperate look up list, as 'customer'  are used in two places in this application (Customer Purchased, and Customer End User)

I have created a test Application from scratch with a small data set and have set up a lookup field with the customer names coming in as a lookup from separate form as a Drop Down in the main form - so I have a handle on how to do that.     However, I cant identify a simply method to convert the above much larger "real" data set into this format (my final data has approx 20,000 records).

I find that once a column is imported, say as a "Single Line" field, it can not be changed into a Drop Down type.

If the column is imported as Drop Down, while the field properties hold all the choices, I want these to be in separate form (to allow future customer edit and reporting forms to be made, and for this "master list" to be accessible for other applications in the future.)

I have tried with a small data set extracting from Excel all the unique customer names and importing that into a form (to be the look up). Then created a new drop down in the main form. I then used lots of searches to select each group of customers (from the original "Single Line" data, and used Bulk Edit to populate the new Drop Down field from the matching choice in the Linked source. Once done, I then deleted the original field. While this got where I wanted to be, it is a very time consuming method and not one I would want to use for the full 20,000 record set (I am not aware of a method to batch copy one column (of single Lines) to another (the Drop Down) columns )

Hopefully someone can give me the benefit of their advice on most convenient method to reach my goal.

Warwick