primary key in query

[Guest]

I use a program called pendragon forms to put access on teh palm and i map
the form onteh palm to a query. in order to append the record on teh palm,
the table or query that i map to needs to have a primary key.

how do i set a primary key on a query?

thank you,
russ

 

[Chris2]

I use a program called pendragon forms to put access on teh palm and i map
the form onteh palm to a query. in order to append the record on teh palm,
the table or query that i map to needs to have a primary key.

how do i set a primary key on a query?

thank you,
russ

Russ,

In MS Access, Primary Keys are set on tables, not on queries. You do
this yourself, either via the GUI (the key shaped icon on the
toolbar), or by CONSTRAINTS in CREATE TABLE or ALTER TABLE DDL
queries.


Sincerely,

Chris O.