Re: [sqlite] Updating key on related table

2011-12-14 Thread BareFeetWare
On 15/12/2011, at 2:58 PM, Jeff Matthews wrote: > Thanks. You are putting me on track. > > Can you describe the properties, collate, nocase, restrict, etc., The "primary key" constraint automatically assigns a new ID to each Customer and Invoice when you insert a new row that doesn't specify

Re: [sqlite] Updating key on related table

2011-12-14 Thread BareFeetWare
On 15/12/2011, at 2:11 PM, Jeff Matthews wrote: > Customer Table > >ID >Name > > Invoice Table > >CustomerID >InvoiceNumber > > When I create a new invoice record for the selected customer, does > Invoice.CustomerID update with

[sqlite] Updating key on related table

2011-12-14 Thread Jeff Matthews
Customer Table ID Name Invoice Table CustomerID InvoiceNumber When I create a new invoice record for the selected customer, does Invoice.CustomerID update with Customer.ID automatically, or do I need to do this