primary key in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Russ said:
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
Click to expand...

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.
 
Back
Top