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...