Bob Sysero llc Dev wrote:
> Dear Dabo-users,
>
> I have a SQLite database that have two tables and both have two fields
> that make up the primary key:
>
> "CustomerID" INTEGER NOT NULL, "StoreID" INTEGER NOT NULL, ...
> Primary Key( "CustomerID", "StoreID" )
If you control the structure, I highly recommend using a single primary key
instead
of a compound one.
> I want to link the two tables Customer and Store using two BizObj for
> each table and then use a Foreign Key to link them together. My first
> question is what is diffrence between BizObj.KeyField and
> BizObj.LinkField?
KeyField is the primary key. LinkField is the field name that is the foreign
key back
to the parent.
> The next question is how do I uses both the CustomerID + StoreID as a
> single key?
self.KeyField = ("CustomerID", "StoreID")
Paul
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
