Search results

Right now only about 1/3 of employees have driver's licenses - only one. but we are getting more so eventually most if not all will have a driver license in my database. so I will keep the license in the staff main table.

I did add the Driver lic to the main form and deleted that table. By what you sent me yesterday telling me to set up empl table with foreign keys. Should that new table have a primary key? Or should one of these FK be the primary key. The Required traing table only has the trainings that al...

I will create a emp_training table as you described to me yesterday. my certificates is just a check box letting me know I received their certificate.

No I didn't mean to send those other posts. I have completed putting the driver's license table into the Main Staff Table. I have deleted the driver lic. table. So now in relationships for all my tables, how should I do it. I'm still a little confused.

so sorry I didn't get to get back to yu from home last night. I had a family emergency it last past 9pm. I was NOT going to bother youthen. would it be possible for you to write down what you're trying to explain on the table relationship I sent you? I think I understand what you're saying...

I thought I would at least send you my relationships of all my tables. I'm getting ready to go home now. However, I will be back on from home to try to get this all figured out tonight. Please let me know what is wrong.

I think that may be my issue..... No matter how hard I tried I do not understand relationships. All my tables have employee numbers. So I assigned Employee number as the primary key on all tables. Since employee numbers cannot be duplicated I thought that was best. Can I attach my data base...

Ok... How do I fix this? I have the employee Number as primary key on all tables. I've set all tables relationships to match the employee number (primary key). Should I have set it up differently? Please help me...I'm getting really stressed just add new employees into all my subforms (as...

Ok ...all looked good until I tried to add a new employee. Before starting I made sure in all my tables this new employee did not exist. It did let me add her employee # (Primary key) and her name (this is what consists my Main form. Within this main form are all my subforms that pertain to...

AGAIN!!!! Thank you so much!!! I had trouble finding where to link in the properties but I finally found it and that was the issue. I thought the links would've automatically linked together when I add a new page to the main form. 👏:)

Ok that work...Now there 1 more issue. all other subforms have 1 record of 1, except for this one subfomr again it has 1 to 136 (total number of employees). so it doesn't match the main form data like all other subforms.

OMG!!!! It worked....Thank You!!!! If I would've known about this forum, i would've joined along time ago. I spent so many hours trying to figure this out. and it was so simple. You will see usually this my dilemma - the small things I just can't get most of the time. 😊

Default view is datasheet Allow data sheet view - No allow Form view - yes

I'm designing an employee database. I'm fairly new to Access; even though I created a very good database approximately 20 yrs ago. I've found working within a database is not the same as designing one. Now that my old one is no longer needed due to new job; I have created another one. I have 8...

I'm designing an employee database. I'm fairly new to Access; even though I created a very good database approximately 20 yrs ago. I've found working within a database is not the same as designing one. Now that my old one is no longer needed due to new job; I have created another one. I have...