I'd like to "grab" the data collected in a detail form after the user has selected "update" or "insert" and pass the "selected TEXTS" from all dropdwonlists to some fields in my tables that will gather that data ...
Let's say for instance that I have chosen a category, a customer and an telephone from 3 different dropdownlists BUT there is a possibility that later on (tomorrow, a month, a year after this happened) that data might change and I need to recreate one specific
"Invoice" in current time but showing the data that was used when the invoice was created (let's say that for for account audit or database audit reasons)
So if I don“t collect that data then the "past invoice" will reflect "current data" not the one thta was used by the time it was generated/created which will be wrong because it will show data which is not true
Member
242 Points
480 Posts
Grab data captured on a detail form
Nov 19, 2012 01:12 PM|klca|LINK
Hi,
I'd like to "grab" the data collected in a detail form after the user has selected "update" or "insert" and pass the "selected TEXTS" from all dropdwonlists to some fields in my tables that will gather that data ...
Let's say for instance that I have chosen a category, a customer and an telephone from 3 different dropdownlists BUT there is a possibility that later on (tomorrow, a month, a year after this happened) that data might change and I need to recreate one specific "Invoice" in current time but showing the data that was used when the invoice was created (let's say that for for account audit or database audit reasons)
So if I don“t collect that data then the "past invoice" will reflect "current data" not the one thta was used by the time it was generated/created which will be wrong because it will show data which is not true
Thanks in advance
Carlos N. Porras
(El Salvador)