Search results

I will check the tblSchools fields you mentioned and see that they pulling the rowID from the tblemployees. I dont' think i set up that look up relationship or anything yet cause i wasn't sure how we were going to handle them. It's a one to many type of relationship that needs to be created for...

Ok Plog. Here's the zip file of my new data tables. Let me know what you think. from here I'll need help building the junction table to assign the employees to the programs and make sure all the data ties together the way it's supposed to.

Hmmm. Well you tell me which is better. I can have up to 20 "meal schedules" per school. And no two schools have the same schedule. I have somewhere in the neighborhood of 2 breakfasts and up to 14 lunches (all part of the contract program), then some schools have snack programs (1 meal) in the...

alright I've got the Employees, JobTitles and Shools tables ready to go with the new structure. I'm about to work on the Schedules table. Now if I'm following you correctly I should have the following fields: School (which pulls from the school table), Desc, StartTime, EndTime, and my checkbox...

Ok so I'll be able to change the information I view so that i get the actual title in the form not the row number then. Right?

Ok when using the autonumber as a primary key field (example: job titles), it defaults to showing the 1st column of the selection in the job title field of the employee table. Is there a way to make it display the second column which is the actual title instead of a record number?

Ok can do. I have a job titles field that I can use for that. When I want to assign an Area Supervisor to a school...how would I limit the selection list to just those titles of Area Supervisor to select from? I have 8 Area Supervisors so I don't want to have to go through all 600 employees to...

I don't track the student name. Just how many total are covered by the sponsor. The programs are per school and most of the time there is only one sponsor per program per school but there can be more than one. So i should add the supervisors and such to the Employee's table or just put all 3...

I'm good with a major structure change. I came here knowing it might come to that. I think the employee table and the school table i have sorted as far as what is going in those. About the schedules table (and I'm mostly sound boarding here): Breakfast and lunch bell schedules will of...

That is bloody brilliant Plog. I like it...a lot. Can you explain a little further about how to implement that?

It might work with two separate junction tables though. What do you think? One for the contract assignments and one for the afterschool assignments? I would just use the individual junction tables to run the different reports. I don't really need the date information on it. If i could just join...

Something like that might work for the summer schools but I don't think it's going to work with the situation I have for contract assignments and after school programs. Let me explain. This is for the food service department so the employees that I'm dealing with are the kitchen managers and...

Great Thanks. Now with regards to employees and their assigned schools. I know I can use a relationship to bring the school into the employee table but when it comes to the after school program is that going to cause an issue down the road if I have to assign an employee to a different school...

Ok good point. So then I should just set the list in the field itself for those types of things. The only reason i added them as separate tables was so that I or someone else in operations could easily add to the lists later on if needed, like with the Cities. Most employees are all in one...

Alright thanks Plog. That's what I thought might need to happen when I mentioned breaking up the tables. I just wasn't sure how it needed to work. I appreciate your input. Before I set to work on this change, will i worry about relationships at this point between the lunch tables and such back...

Now since my DB is split, I'd want to use that query as the row source for a combo within the form itself and not in the ASM table directly as I have it set now (which is the after school program where i have to assign an employee to a different school), yes?

Thanks Eirman. I've zipped it up so let's try again.

re: exclusion query So if i make a query that excludes the inactive records, then I would set my look up fields to that query instead of to the employees table? Is that right?

Ok trying again. It's an accdb file 1.41 mb so if it doesn't work this time I have no idea why. I'm using the right file type and it's under the max size allowed.

Thanks for the reply. I'm not going to address all of the irrelevant issues with my school district and how they operate and why we are doing it the way we are. None of that is germane to why I'm here. Access is what I have to work with and so Access is what I'm using. Re: Breaking the tables...