Hi Craig,
There are 3 ways to populate drop down contents for TracerPlus and each has their own value. Item 2 is probably the best fit for your question. I would suggest checking out our TracerPlus channel on YouTube where there are a ton of videos describing how to sync data with TP Connect. Let me know if that helps.
1. Directly in TP Desktop. You can manually enter (or import from file) a list of dropdown items. This is especially useful for more static type values like Condition or Category, etc.
2. Via TP Connect syncing. You can configure a sync process to populate Drop Down items from a database, text file, Excel sheet, etc. Similar to syncing your collected data, you can setup a sync process with the destination of your data to be TracerPlus and then selecting the appropriate field to use to populate. This is most useful when your drop down items are more dynamically changing; maybe a list of order numbers or similar.
3. Import of a text file via Menu-->Import. This is arguably the least common method but can be useful if you are in a network restricted environment or for some other reason that you cannot easily sync data.