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
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 C
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 manually?
3 matches
Mail list logo