Cascaded forms?

[Ramesh]

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

 

[Guest]

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