I am working to create a time-keeping report form.
I am using a contact table to create a combo box list which contains the contact names (text-type) and their contact ID (Interger-type).
I allow the user to enter the time-keeping form, find his/her name from the combo box and then enter time values into various work-type fields.
The data is then saved into the WorkLog table. When I review that table, only the contactID is populated. The ContactName is left blank.
Is it possible to add BOTH fields from the combo box (ContactID and ContactName) into the WorkLog Table?
Thanks so much for any assistance! MBA
I am using a contact table to create a combo box list which contains the contact names (text-type) and their contact ID (Interger-type).
I allow the user to enter the time-keeping form, find his/her name from the combo box and then enter time values into various work-type fields.
The data is then saved into the WorkLog table. When I review that table, only the contactID is populated. The ContactName is left blank.
Is it possible to add BOTH fields from the combo box (ContactID and ContactName) into the WorkLog Table?
Thanks so much for any assistance! MBA