After much searching and not finding a solution I hope that someone can share
some pearls of wisdom. I have a single table (multiple fields) containing a
job number and sequence number. I simply wish to create a new field that has
the job number and sequence number combined. Hmmm sounds simple enough, but I
am stumped! Job #1000 seq #1 would become 1000-1

I wish to use this new field as a unique index qualifier against a
transaction table.

Even though I have searched the discussion group boards, and have tried some
of the solutions, nothing works.

I am using Excel 2002, and hitting a FoxPro database.

Any help, guidance would be greatly appreciated. Thank you in advance!