Re: thread318-324211

[liaml1]

With respect to thread318-324211 . I would like to know how you can create a key field that is made up of multiple colums. For example, if you have an InvoiceHeader table and an Invoice Details table and you want the InvoiceDetail table's key to be the invoiceNumber and LineNumber how could you achieve this in Pervasive?

Liam

 

[mirtheil]

If you are using a CREATE INDEX statement, you should just specify multiple columns:
CREATE INDEX idxSegmented on tblTableName (Field1, Field2)
If you are using the Create Table Wizard, you should right click on the index and select "Add Segment" (this applies to V8).

Personally, I would strongly suggest using the CREATE INDEX statement.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[liaml1]

Thanks, and how do I link two tables together through a common field?

Liam