I wish to use this new field as a unique index qualifier against a
transaction table.
-------------------------------------------------------------------------------------
You can't create a new qualifier (Primary Key) that I know of, simply by a
Query
Creating a new unique qualifier (Primary Key) at this point?
Are you talking about the Primary Key?
What has been the unique qualifier (Primary Key) to this point? Auto
Numbering?
Most data bases are not structured in a way that allows the changing of
unique qualifiers after construction is complete.
I don't know in FoxPro if it can be done, If it were me, I would build a
new data base (ground up) and then import the existing records into the new
data base, through excel, or create new froms in FoxPro for adding records
with the new qualifier, then the records could take on the new unique
qualifier (Primary Key) in the methods and the limitations of your choice.
Its been my experience that altering an existing Primary Key can produce
unexpected results, if it can be done at all.
I'm not familiar at all with FoxPro only Access construction, so I can't
offer too much insight on any of the FoxPro construction. I would request
information from FoxPro about changing the data base Primary key before
altering it.
I would very much like for you to let me know through this thread, all your
findings on making the new alterations.
--
William<"M"




"CJ" wrote:

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!