I don't know if this is possible..... Can a form be partially populated with data from one table, the remaining cells be completed by our employees, and all of the data on the form be saved to a second table. I would like to enter an account #, have the account # and patient name automatically complete (the info would come from table 1)- this is to verify that the employee has entered the correct account #. They will continue to complete the remainder of the form. Then I would like everything to be saved to table 2.
I'm getting desperate! Any help would be GREATLY appreciated.