SeaweedOPM
Technical User
I have two tables that are almost identical. The thing is that I want to use one form with a button or dropdown list to change the forms underlying table. All of the columns are named the same.
Basically it was created this way because one table contains around 2,000 records of potential customers that we need to contact back. The other table is set up to enter in the same info when a customer calls us.
I could use one table for this and just use a column that contains identifying information. The problem is that I don't want to alow changes to the existing list plus the setup for filters and the code i have remembering the last used record would not work right.
please let me know if there is a variable that i can use in the textbox's source to be changed upon the after update of a drop down menu or anything for that matter.
Basically it was created this way because one table contains around 2,000 records of potential customers that we need to contact back. The other table is set up to enter in the same info when a customer calls us.
I could use one table for this and just use a column that contains identifying information. The problem is that I don't want to alow changes to the existing list plus the setup for filters and the code i have remembering the last used record would not work right.
please let me know if there is a variable that i can use in the textbox's source to be changed upon the after update of a drop down menu or anything for that matter.