Primary Key export

[Drunkenneo]

I have a primary Key in table with input mask as M00000, but when exported it comes without M only digits are coming any suggestions on this

 

[CJ_London]

input masks are only used in forms and reports - you need to modify your export to incorporate the mask - something like

PKey:"M" & format([primarykey],"00000")

 

[Drunkenneo]

And in other hand if i want to define my own primary key in it without using system ones, then what need to be done.

 

[CJ_London]

I don't understand the question - provide some examples

 

[Drunkenneo]

Internal No Name Product
(it is unique for
all transactions
and goes to client too)
-----------------------------------------------------------------
M00001 Nhasd afdasasdad
M00002 asfdadas asdasdasd

Likewise current it is on Autonumber and displays the same result as my input mask is "M"00000 but while sending the reports to client it have intenal numbaer as 1 and 2 and so

 

[CJ_London]

so is the client internal number equivalent to your number i.e.

M00001=1
M00033=33

etc

or
M00001=1
M00033=2

 

[Drunkenneo]

Yes the first option was right for primary key

 

[CJ_London]

So in your query that you are exporting have the primary key appear twice, once formated with M00000 and once not.

 

[Drunkenneo]

So in your query that you are exporting have the primary key appear twice, once formated with M00000 and once not.

There is no duplication in Exporting:

As i see table i see as M0001, .... so on...

Where as it export as 1, 2...so on.

Thinking if i can make my own primary key for of this kind then it can be avoided too..any light on it>?

 

[CJ_London]

Sorry no, I thought I did but I don't understand what you are trying to achieve

 

[pr2-eugin]

Drunkenneo, are you saying that the primary key field in the table has a Format set? as "M"00000? If so when you do an export only the actual Data will come out. If you need the M part, then do as CJ suggested, create a new column in the Query setting the desired format and then export the Query.