I'm trying to submit a purchase through a submission for that gets listed in the purchases table (this part is easy), but then I need the inventory table to add the value purchased for that item to the current value in the table for that item to create a new value for that item that includes what was purchased already & what has just been purchased. I've been thinking on this for a while and can't seem to understand how to pass the parameter to two spots + have the 2nd spot get this parameter added to its current value. The purchases table will log purchases per item per date purchased while the inventory table will have quantities per item with only one record per item.
I'm thinking that I need to have some javascript that tells the inventory table to "get" the new purchases and "add to" the current value. Any suggestions here?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
zalipresents
I have 2 tables for T-shirts:
1 - purchases
2 - Inventory
I'm trying to submit a purchase through a submission for that gets listed in the purchases table (this part is easy), but then I need the inventory table to add the value purchased for that item to the current value in the table for that item to create a new value for that item that includes what was purchased already & what has just been purchased. I've been thinking on this for a while and can't seem to understand how to pass the parameter to two spots + have the 2nd spot get this parameter added to its current value. The purchases table will log purchases per item per date purchased while the inventory table will have quantities per item with only one record per item.
I'm thinking that I need to have some javascript that tells the inventory table to "get" the new purchases and "add to" the current value. Any suggestions here?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.