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

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

--
Wayne
Manchester, England.



"Ramesh" wrote:

> 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
>
>
>