SkipMartin
MIS
I am attemting to create an employee database to replace a spreadsheet used for the same purpose.
Each record has company related info and personal info.
Issue 1:
I would like to allow the manager adding new records to add info to both records in one continuous action, but it does not seem like you can append to two different tables using the same single record form. Does anyone have any advice or examples of how this can be done.
Issue 2:
I am very familiar with query and table design, but have no experience with forms or VBA. I would like to have view functions, edit functions and new record functions for the database. How do you use a popup form to filter the records that need to be edited or viewed based on the value entered by the user. ie. a manager enters his name to view all of his records or an employee id to edit or view only one record?
Thanks
Each record has company related info and personal info.
Issue 1:
I would like to allow the manager adding new records to add info to both records in one continuous action, but it does not seem like you can append to two different tables using the same single record form. Does anyone have any advice or examples of how this can be done.
Issue 2:
I am very familiar with query and table design, but have no experience with forms or VBA. I would like to have view functions, edit functions and new record functions for the database. How do you use a popup form to filter the records that need to be edited or viewed based on the value entered by the user. ie. a manager enters his name to view all of his records or an employee id to edit or view only one record?
Thanks