Why oh why is it that when I drag the field to the column area it is fine..I
then drag the second one to this area and it gets lost?

Sometimes it does not list all of the entries that field is supposed to
contain. Do I always have to double-click in the fields box to make it
appear.

For example:

Serial #: 777777
Serial #: 999999
Serial #: 77777