SO i have attached a sample of my FE and BE databases. There is no sensitive data. I am trying to use a combo box to select a value and have it stored in a table so I can use it later in a report but also have the value show up on the form.
The form is Case Details - page case information
the table I want the combo box to use is tblstatuscomments
the table I want the value to be stored in is tblcomments. You will see that in tblcomments I want the PK from Tblclaims (invoiceId) to be also be stored so the linkage is there. Can someone help please