HI,
I have a Customer table and an Orders table. I have another table with
PaymentSchedule table containing Instalment promises for each order.
Ideally i d create a form where I can either select an exisitng customer or
create a new customer. Then select an order or create a new order. Then
enter or modify the instalment details.
What s the best way i could achieve this? is there some form of cascaded
forms i could create?
Thanks
Ramesh
Wayne-I-M - 21 May 2007 10:32 GMT
Hi Ramesh
Link the tables using the primary field of Customer table.
Create 2 new forms based on both table.
Link the forms - again using the control containing the Customer table
primary field.
Make the customers the main form and insert the other (orders) as a sub form.
Hope this helps

Signature
Wayne
Manchester, England.
> HI,
>
[quoted text clipped - 10 lines]
> Thanks
> Ramesh