Search results

We can forget the PIR Table. this is keeping track of all staff who had been hired and left during the program year. But I will have this information one my DB is done correctly.

ok...I'm ready to tackle the issues with my current database. As you know there's a lot of work to be done. Where should I begin? You suggested combining some tables and changes their PK and creating FK. I'm ready whenever you are able to help me to get this done right and most effective.

ok. I'll follow you on the new thread.

OMG!!! Thank you so much for all this information. So it wasn't all me "not getting it"??? If you will work with me on getting this correctly I will definitely have the time. Is there some way to have a quick way for the database right now? Meaning getting reports in queries. What I...

Yes!!! 1st Aid/MAT is only done once by each staff. When it's ready to expire they redo it and I update the new expire dates. Required trainings are trainings every staff who work with children are mandated to take every 2 years. I keep track of all those dates to remind staff when it's time...

OK...If you're still willing to work with me. I am so sure you're so sick of me, honestly I'm trying. Another sleepless night trying to figure why my queries are not working out. This is what I've found. When I did a query showing me who had not taken CPR before and their experation dates for...

Now that I've gotten my relations right or better(hopefully), the exact queries I did in my previous DB (before redoing relations) I don't get any data. All is blank. I ran the simpliest, F. name and L. name and Employee numbers = that worked. However, all other queries are all blank. So...

OK... I clean up most of my mess. How am i doing so far? I took a picture of my screen since I'm working from home right now. Hope you will be able to look at my relationships now. Let me know if there should be any more revising that you can see.

I did change 2 of my tables yesterday due to having the employee number as PK. Now it's Employee ID as PK (auto). So thank you for that. I did misunderstand you about the junction table. I will redo my relations and see I do. I did know not to use those special characters but had forgotten...

I created a new database. There was a huge problem with it because I used Employee Number as a primary key on all my tables. So after some help on here I had to redo a couple of tables. I created different PK on all tables. I can enter all information on my Main form and all my Sub Forms...

Also --- one more thing. What relationships need to be done to have employee F & L names go into other tables when I enter on my main form?

You are right about that. You have been so helpful. I have been looking trying to get help and I just came acros this forum. I am so glad that I had this help rather than further down the line.

Ok you asked fo rit. As I was breaking this tracking for you to see - I was thinking I probably have to mput that training categories for each staff indiviually. Well...Yu look at this and you'll see what I mean. also, remember at this point I have 140 staff to my actual list.

Let me send you a small sample of what my excel sheets look like. Maybe by looking at it you may be able to help me find a way to link it to my database and calculate all total hours into my database. I will send you about 5 employees to let you know what I'm working with. Keep in mind once...

I just got table relationship. I can't take "normalizing query" right now...LMAO!!! My next big project is to figure out how I'm going to do my training log. I have it in excel and I want to keep it there (I think) and link it to the database. However, I set it up years ago and it will not...

Thank you!!! I finally got that too. I'm slow at learning because I'm a very visual person, but once I get it - I have it!!!

I want to thank you so much for all the help you've given me the last couple days. After following your table relationship in the example you gave me, that did it. I was very confused when I started but I did eventually get. I had to redo 2 of my tables - keying all information in (I've been...

I want to thank you so much with all this help. I have created some new tables and I will see how they work. If I use auto number then the FK can be employee number for relations for the Employee table PK(auto) to relation to Employee number (which I will key in) on the training table?

Ok...going through everything you sent me. I am restructuring my database somewhat. I see you you have in emptble a primary key (automatic) and in the trainingtbl you have trainingID as primary key (automatic). My PK is employee Numbers (not automatic). so would I use a different PK in...

In the table relationships I sent you yesterday. You did give me suffestion to create a employee training table with EmpID_FK / TrainngID_FK / TrainingDate / Certificate (checked if received). How do I mark the FK's - is there a PK that I will need to add to this table?