primarykey

i have a table in ms-access named AccTable

with fields MemberID and AccountType

The MemberID is primary key in Master table, and in this table(AccTable) , it is foriegn key.

In AccTable table, how can i set MemberID and AccountType fields as primary key. (I dont want to set any other field as primary key)

pls tell me



Answer this question

primarykey

  • Rick Murtagh

    Use the Server Explorer to open the table and set the PK designation.

  • JonathanV

    Or if you are in Access, go to Design view of the table and Right-click the field, then select "Primary key"

  • primarykey