A
Alp Bekisoglu
Dear Experts,
I'm off of my witts in trying desperately to get the following going (for my
own use):
I have an items list stored in a table, participation in another and
requested items yet in another. What I need to do is:
On a form give the ability to choose the item (combobox)
- which once chosen will update fields(item_code, item_price, etc) on the
form
- on entry of the number of items(quantity) and (if any) discount rate
entered, total is calculated and displayed (both next to the item line as
item total and as grand total(Sum) in form footer)
- This continues until items requested are finished
- Each time (exiting quantity and or rate fields) the Sum field on form
footer is updated
- On clicking "Close" button the Sum is appended via a query into
transactions table, all items that were given a quantity are updated as
"used" in a Yes/No field in "requested_items" table
What I have done so far:
- Have a form to enter the relevant chosen itmes
- have the form display the items' calculated total on the same record line
- have the form footer Sum field to update to the grand total (flaky but
does so)
- get all but the last entry into the items requested table (?)
- get all but the again the last entry into the calculated form footer Sum
filed(?)
What I couldn't accomplish:
- Get each item into the requested_items table (most is recorded except for
the last entry)
- Get the transactions table updated with the "correct" Sum (sum now only
includes upto the last entry)
- Update the "used" Yes/No field for each entry in "requested_items" table
for this transaction to -1(or True) in the transactions table
I don't want to flood the NG any more but will send all further info if
needed (SQL's of queries, codes, etc.).
Any help in "clearing" my ageing mind would be highly appreciated. Will
inform of personal email if necessary.
Thanks in advance.
Alp
I'm off of my witts in trying desperately to get the following going (for my
own use):
I have an items list stored in a table, participation in another and
requested items yet in another. What I need to do is:
On a form give the ability to choose the item (combobox)
- which once chosen will update fields(item_code, item_price, etc) on the
form
- on entry of the number of items(quantity) and (if any) discount rate
entered, total is calculated and displayed (both next to the item line as
item total and as grand total(Sum) in form footer)
- This continues until items requested are finished
- Each time (exiting quantity and or rate fields) the Sum field on form
footer is updated
- On clicking "Close" button the Sum is appended via a query into
transactions table, all items that were given a quantity are updated as
"used" in a Yes/No field in "requested_items" table
What I have done so far:
- Have a form to enter the relevant chosen itmes
- have the form display the items' calculated total on the same record line
- have the form footer Sum field to update to the grand total (flaky but
does so)
- get all but the last entry into the items requested table (?)
- get all but the again the last entry into the calculated form footer Sum
filed(?)
What I couldn't accomplish:
- Get each item into the requested_items table (most is recorded except for
the last entry)
- Get the transactions table updated with the "correct" Sum (sum now only
includes upto the last entry)
- Update the "used" Yes/No field for each entry in "requested_items" table
for this transaction to -1(or True) in the transactions table
I don't want to flood the NG any more but will send all further info if
needed (SQL's of queries, codes, etc.).
Any help in "clearing" my ageing mind would be highly appreciated. Will
inform of personal email if necessary.
Thanks in advance.
Alp