Sub Folders?

[TallMan]

Hello Group,

I currently have a master table of all new employees that come to my company. I was wondering if there is a way to set up another table that receives rows of information into it after the employee has been with us three months from their start date?

I am not sure what this function would be called or where to begin looking as I am new to access.

Thank you for your time.

 

[poporacer]

I am not quite sure what you are wanting to do, what kind of information are you wanting to add? Is it the same for all employees after they hit the 3 month mark? I think you can accomplish this by using 3 tables. The first one will just have the basic employee information, ie. name, position, date of hire. The second one will be a list of the items you want to add and the third will be a list of employees and the added information. This information can be sorted and organized with queries.

 

[gemma-the-husky]

you dont need an extra table for this

you just need a query that filters out the employees with less than 3 months employment, based on the start date.

at worst have a flag on the table to show probationary employee, full employee - but you dont have to have this - much easier than having 2 tables