Hello,
This must be easier than I think.
I have a form that has a bunch of fields that do select statements to retrieve there data…Example customers field pulls in the customers into a drop down to select from.
This all works good but I would like to save the true values of the selects into the database table instead of the linked id’s that its currently saving. Example: (Linked value:100). 100 is actually “Walmart” and I want the value “Walmart” saved in the database not “100”.
I don’t want the linking values to change the master table after the fact if say a customer detail is changed. I want that committed record to stay frozen without any changes.
How can I do this?
Thanks for any help.