Access 2007
In order to better design the data structure/table design, I need the ability to add a new record to a table based on data from a form as well as a value that is not in the form's table.
For example:
I am entering patient information (ID, name, birthdate, address, etc.). This patient may be admitted and discharged multiple times at one or more hospitals, so I need another table that will have PatientID, HospitalID, AdmitDate, DischargeDate.
My goal is to give the user the ability to maintain that by going through the Patient form. Without using a subform, is it possible to create fields in the form and have my record insert code reference them? So, on a patient record (which would already have the PatientId from the Patient table), could I have some "floating" fields where the user could enter the admit/discharge dates so I could use them in the code as inputs to the code to insert a new record into the AdmissionHistory table?
Thanks!
In order to better design the data structure/table design, I need the ability to add a new record to a table based on data from a form as well as a value that is not in the form's table.
For example:
I am entering patient information (ID, name, birthdate, address, etc.). This patient may be admitted and discharged multiple times at one or more hospitals, so I need another table that will have PatientID, HospitalID, AdmitDate, DischargeDate.
My goal is to give the user the ability to maintain that by going through the Patient form. Without using a subform, is it possible to create fields in the form and have my record insert code reference them? So, on a patient record (which would already have the PatientId from the Patient table), could I have some "floating" fields where the user could enter the admit/discharge dates so I could use them in the code as inputs to the code to insert a new record into the AdmissionHistory table?
Thanks!