I have 3 tables that are linked in relationship. Customers, orders, and
order details.
I have them on one form (customers) and 2 subforms (orders and order
details.)
I need the orders to be linked to customers and order details to orders.
This all works well with relationship.

My problem is I need to put up to 12 orders for one customer at one time
with a separate form and code.
I have made the form, and have all the required data I need to put into the
tables. What I can't work out, is how to add records in orders (and order
details) from outside the forms.

I have tried
DoCmd.GoToRecord , , acNewRec

but it just makes a new record on customers (main form)
I need to make a new record on subfor relating to customer relationship.

Hope this is understandable and someone can help me.

Thank you

Fixed it. Thank you

"Colin Possamai" <(E-Mail Removed)> wrote in message
news:43f6a610$0$18699$(E-Mail Removed)...
>I have 3 tables that are linked in relationship. Customers, orders, and
>order details.
> I have them on one form (customers) and 2 subforms (orders and order
> details.)
> I need the orders to be linked to customers and order details to orders.
> This all works well with relationship.
>
> My problem is I need to put up to 12 orders for one customer at one time
> with a separate form and code.
> I have made the form, and have all the required data I need to put into
> the tables. What I can't work out, is how to add records in orders (and
> order details) from outside the forms.
>
> I have tried
> DoCmd.GoToRecord , , acNewRec
>
> but it just makes a new record on customers (main form)
> I need to make a new record on subfor relating to customer relationship.
>
> Hope this is understandable and someone can help me.
>
> Thank you
>

I'm trying to do something similar, how did you fix it?

Thanks
Marc Berman

"Colin Possamai" <(E-Mail Removed)> wrote in message
news:43f6cdf6$0$15128$(E-Mail Removed)...
> Fixed it. Thank you
>
> "Colin Possamai" <(E-Mail Removed)> wrote in message
> news:43f6a610$0$18699$(E-Mail Removed)...
>>I have 3 tables that are linked in relationship. Customers, orders, and
>>order details.
>> I have them on one form (customers) and 2 subforms (orders and order
>> details.)
>> I need the orders to be linked to customers and order details to orders.
>> This all works well with relationship.
>>
>> My problem is I need to put up to 12 orders for one customer at one time
>> with a separate form and code.
>> I have made the form, and have all the required data I need to put into
>> the tables. What I can't work out, is how to add records in orders (and
>> order details) from outside the forms.
>>
>> I have tried
>> DoCmd.GoToRecord , , acNewRec
>>
>> but it just makes a new record on customers (main form)
>> I need to make a new record on subfor relating to customer relationship.
>>
>> Hope this is understandable and someone can help me.
>>
>> Thank you
>>
>
>