I have created a simple database with only 2 tables: tblCorps and tblEmployees.
Each table has an autonumber primary key.
The primary key of tblCorps appears as a foreign key in tblEmployees.
There is a form frmEmployees where employees can be added. The form has a combo box which lists the available corporations which an employee might work for. The fomatting of the combo box involves two columns: the primary key of tblCorps (which is the bound column) plus CorpName. However, only the CorpName is visible to the database user. (The autonumber primary key would mean nothing to the end user).
I want the end user to be able to add a new CorpName. The frmCorps should then open up, with the new CorpName already appearing in the appropriate textbox of frmCorps. The end user can then fill in the remaining field of frmCorps. Ideally, frmCorps should then close and the user should return to the original form (that is frmEmployees).
I have attached some jpg files to help explain this db.
Thanks for any advice.
Each table has an autonumber primary key.
The primary key of tblCorps appears as a foreign key in tblEmployees.
There is a form frmEmployees where employees can be added. The form has a combo box which lists the available corporations which an employee might work for. The fomatting of the combo box involves two columns: the primary key of tblCorps (which is the bound column) plus CorpName. However, only the CorpName is visible to the database user. (The autonumber primary key would mean nothing to the end user).
I want the end user to be able to add a new CorpName. The frmCorps should then open up, with the new CorpName already appearing in the appropriate textbox of frmCorps. The end user can then fill in the remaining field of frmCorps. Ideally, frmCorps should then close and the user should return to the original form (that is frmEmployees).
I have attached some jpg files to help explain this db.
Thanks for any advice.