By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,479 Members | 2,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,479 IT Pros & Developers. It's quick & easy.

Assistance with Posting Multiple Payment Activity

P: n/a
I'm not certain if this is doable in the manner explained below, but
surely there have been others who have done something similar. So
whatever insight and assistance that can be provided will be much
appreciated.

I working with a separate Update Query (well several) that consolidate
various goods from separate tables for access and selection on a
sales/order invoice form. The data which is available is the
TagNo,ItemDescrip, Quantity and Price. Running another Update Query to
post the sold information (SoldDate and PriceSold) back to the
respective tables works fine for single items only, where there is one
SoldDate, one PriceSold and one corresponding IDTagNo.

The problem that I have attempted to resolve is related to Bulk items
where there is one main form/table with two subforms/tables - one for
purchases and one for sales. The Bulk sales are of course multiple
postings. For example the main form contains general information
regarding the product, such as hats, with purchases entered separately
on a subform, and the sales entered on another subform. Of course, the
main form will have a single IDTagNo and of course each entry on the
subforms have another ID number. One of the benefits of running the
Update Query for the single items mentioned above, is that if there
are any changes made it will be updated along with the new postings
the next time it is run. It seems that this cannot work for the Bulk
items because of the subform and multiple postings, or can it? What
criteria could be used?

Any thoughts or suggestions would be welcomed.

Thanks, Dalan
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Dalan,

I have a hard time understanding your project. Perhaps you can describe your
tables better. We don't need to know the fields necessarily, but we do need
some sense of how the different entities are represented. Without that, it's
difficult to offer query advice.

-Todd Matson
"Dalan" <ot***@safe-mail.net> wrote in message
news:50**************************@posting.google.c om...
I'm not certain if this is doable in the manner explained below, but
surely there have been others who have done something similar. So
whatever insight and assistance that can be provided will be much
appreciated.

I working with a separate Update Query (well several) that consolidate
various goods from separate tables for access and selection on a
sales/order invoice form. The data which is available is the
TagNo,ItemDescrip, Quantity and Price. Running another Update Query to
post the sold information (SoldDate and PriceSold) back to the
respective tables works fine for single items only, where there is one
SoldDate, one PriceSold and one corresponding IDTagNo.

The problem that I have attempted to resolve is related to Bulk items
where there is one main form/table with two subforms/tables - one for
purchases and one for sales. The Bulk sales are of course multiple
postings. For example the main form contains general information
regarding the product, such as hats, with purchases entered separately
on a subform, and the sales entered on another subform. Of course, the
main form will have a single IDTagNo and of course each entry on the
subforms have another ID number. One of the benefits of running the
Update Query for the single items mentioned above, is that if there
are any changes made it will be updated along with the new postings
the next time it is run. It seems that this cannot work for the Bulk
items because of the subform and multiple postings, or can it? What
criteria could be used?

Any thoughts or suggestions would be welcomed.

Thanks, Dalan

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.