On 07/04/2007, at 6:45 AM, Solveig L Haugland wrote:
Hi,
In Base, when you create a table using the wizard, there's wizard
window for specifying the primary key. It can be a new field, an
existing field, or an index, a combination of two or more fields.
It's this third option that I need help with.
Creating an index to use as primary key works fine in the wizard,
but I want to be able to use an index as the primary key when
creating a table in design view, too. I have found the index
design window, but I haven't found how to specify a particular
index to use as the primary key for the table, in design view.
Hi Solveig,
A simple solution actually for this one. In the design view in the
very first column (the row number), you can right-click and choose to
set primary key. If you need a composite index, select more than one
field and then right-click and choose primary key.
Regards
Jonathon
--------------------------
Jonathon Coombes
OOo Knowledgebase:- http://mindmeld.cybersite.com.au
http://www.cybersite.com.au
http://www.training4linux.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
