Hello All,
I have a simple form with save / cancel buttons and I want to run an if statement (or something) on click of the save button that will save the entry into the table the form is used for but also create an entry into a different table that will copy certain fields into specific fields in the other table.
Form - Homevisits
Table 1: Homevisits COPY TO Table 2: ClientNotes
Field 1: Home visit date COPY TO Field 1: NotesDate
Field 2: Notes COPY TO Field 2: Notes
Field 3: User Modified COPY TO Field 3: User Modified
field 4: Date Modified COPY TO Field 4: Date Modified
Field 5: Time modified COPY TO Field 5: Time Modified
Field 6: ClientID COPY TO Field 6: ClientID
I would appreciate any direction here. Ive been looking all morning for something suitable but havent had any luck.
Thanks,
I have a simple form with save / cancel buttons and I want to run an if statement (or something) on click of the save button that will save the entry into the table the form is used for but also create an entry into a different table that will copy certain fields into specific fields in the other table.
Form - Homevisits
Table 1: Homevisits COPY TO Table 2: ClientNotes
Field 1: Home visit date COPY TO Field 1: NotesDate
Field 2: Notes COPY TO Field 2: Notes
Field 3: User Modified COPY TO Field 3: User Modified
field 4: Date Modified COPY TO Field 4: Date Modified
Field 5: Time modified COPY TO Field 5: Time Modified
Field 6: ClientID COPY TO Field 6: ClientID
I would appreciate any direction here. Ive been looking all morning for something suitable but havent had any luck.
Thanks,