I have a form which modifies the 'calls' table. The calls table has customer ID which is linked to customer ID in the customers table.
Customer | Calls
-------------------------------------------------
Customer ID | Call_ID
CustName | Customer ID
Notes | Notes
I want to be able to click a button on my form to copy the contents of the 'notes' field on my form, onto the end of a notes memo field in the customer table, while still having the text be saved to the relevant call record.
Can anyone help?
Adam
Customer | Calls
-------------------------------------------------
Customer ID | Call_ID
CustName | Customer ID
Notes | Notes
I want to be able to click a button on my form to copy the contents of the 'notes' field on my form, onto the end of a notes memo field in the customer table, while still having the text be saved to the relevant call record.
Can anyone help?
Adam