Search results

  1. N

    Insert into multiple tables

    Bob, Thanks a million. That helped a lot.
  2. N

    Insert into multiple tables

    Yes a sample would be great if it's not too much bother
  3. N

    Insert into multiple tables

    Ah right. The OrderDate will be the current date. I will just enter that with the date() function. The payment method I haven't really looked at yet. I was thinking that maybe that can be amended to the record in another form once the record has been created.
  4. N

    Insert into multiple tables

    Hey thanks for the reply. OrderDate is a date/time type and payment method is a text type. And yes OrderId is an autonumber.
  5. N

    Insert into multiple tables

    Hi all I'm new to microsoft access and vba programming. So to start i made two tables. One called customers with these fields: CustId(Primary Key) Firstname Lastname Company Email The other called Orders with these fields: OrderId(Primary Key) OrderDate CustId(Foreign Key) PaymentMethod I...
Back
Top Bottom