Cascaded forms?

R

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
 
W

Wayne-I-M

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
 
Top