G
Guest
Hi,
I'm hoping someone can shed some light on a particular problem I'm having
with a form. I have a database that has been functioning well for quite a
while. Now I need to use the same database and rearrange some aspects as to
how it works. Currently, there is a main form with company info, a subform
with quote heading info, and a subform in datasheet view that lists and
calculates all parts to be quoted. No problem - a list of parts with one
quoted amount.
Now I need to have same forms but the quote will sometimes have several line
items with list of parts to make up each line item quoted amount. Can
someone please tell me how to go about having a list of parts in the second
datasheet subform and each be separate for each line item? I hope this is
clear enough to understand what I'm trying to do. As always, any help is
much appreciated.
Thanks,
Pam
I'm hoping someone can shed some light on a particular problem I'm having
with a form. I have a database that has been functioning well for quite a
while. Now I need to use the same database and rearrange some aspects as to
how it works. Currently, there is a main form with company info, a subform
with quote heading info, and a subform in datasheet view that lists and
calculates all parts to be quoted. No problem - a list of parts with one
quoted amount.
Now I need to have same forms but the quote will sometimes have several line
items with list of parts to make up each line item quoted amount. Can
someone please tell me how to go about having a list of parts in the second
datasheet subform and each be separate for each line item? I hope this is
clear enough to understand what I'm trying to do. As always, any help is
much appreciated.
Thanks,
Pam