J
John
I have an orders form which is based on the Northwind
Orders form, which I using for purchase orders. I have
successfully set up my subform to the order form to
select multiple products, but I need to provide further
information on each product concerning dimensions, in
this case heights and widths of sheet materials. There
might be many dimension lines to each product. My user
then needs to select another product, and back to
dimensions again, until the order is complete.
I would appreciate any suggestions on the best way to
accomplish this. I have tried to start a subform to the
subform but this is going nowhere. I cannot select more
than one instance of each product as this creates
duplicate records in the underlying table.
Many thanks!
Orders form, which I using for purchase orders. I have
successfully set up my subform to the order form to
select multiple products, but I need to provide further
information on each product concerning dimensions, in
this case heights and widths of sheet materials. There
might be many dimension lines to each product. My user
then needs to select another product, and back to
dimensions again, until the order is complete.
I would appreciate any suggestions on the best way to
accomplish this. I have tried to start a subform to the
subform but this is going nowhere. I cannot select more
than one instance of each product as this creates
duplicate records in the underlying table.
Many thanks!