I have noticed that under tables it says that my data file has 1 field and zero records even though when i open the file in fm it has over 40k records, this may be why the box does nothing i guess, but surely it should be seeing all the records ?
A bit more detail would help. You describe two tables here, so it is very possible that you have 0 records in your new table, but 40K records in the existing data table.
You don't actually need that second table, though you could set up a portal from it to your existing data table if you want to. If you relate the two tables by a field and use the field from your new table for your drop down, selecting different values could bring up different records in your portal.
It's also possible to define a field for your drop down as a global field and use a script trigger to perform a script that uses the value you selected in the drop down to perform a find for all records matching the value you selected.
In either case, its' not a good idea to use an existing data field from your data table for your drop down as selecting a value in it might change the value of that field in one of your existing records.
Ok thanks for the info, i stripped everything out , added it again and it worked this time !