Search results

I've got that part sorted out and now have my various supervisory fields looking up properly without errors to the staff type field in tblEmployees. I've detached the tblJobTitles from Employees and done away with the Title field in tbl Employees. I'm now ready to start working on how to...

Ok in doing that, I think I can remove the Area Supervisor, LED, Custodial Supervisor and the Principal titles from tblJobTitles and use them as the staff type designation along with kitchen staff. I'll leave the Substitute job title because they can be assigned to ASM, Concession and Summer...

Good Morning Plog. I hope you had a good weekend. This morning I need to work on the structure for schedules, programs, employee assignments and schools. We had started talking about possibly doing away with the title field in Employees and instead using another junction table to assign the...

Well perhaps not the only question I have left. How will this new junction table work with the junction table we were planning to assign employees to programs or do I just integrate of it together in one junction table?

Now that you mention it. A junction table may be the best way to go. I hadn't thought about this before but each school is "budgeted" for a specific number of each type of position. Example: Mission can have 1 manager, 1 assistant manager, 1 7 hour cook, 1 6.5 hour cook. 2 6 hour cooks and 3 5...

Its numeric. Here this may be easier, I'll just attach my tables here.

I'm getting a data type mismatch error.

Ok I think I've done this right but I want you to check me. In the AreaSupervisor field on tblSchools, my Row Source code now looks like this: SELECT [tblEmployees].[RowID], [tblEmployees].[LastName], [tblEmployees].[FirstName], [tblEmployees].[MI], [tblEmployees].[Title] FROM tblEmployees...

I'm afraid you've lost me again. If I do a straight look up (which returns all the employees in tblemployees, the row source code looks like this: SELECT [tblEmployees].[RowID], [tblEmployees].[LastName], [tblEmployees].[FirstName], [tblEmployees].[MI], [tblEmployees].[Title] FROM tblEmployees...

Also, when making queries for my look up fields (administrative staff vs kitchen staff) will that cause a problem once I split the database with the query not being in the same place as the tables? Or does that not matter?

When I'm making the junction table for the subs and their area, can I still make an option for "all areas" or will I need to force the use to enter separate records for all 4 areas?

Thank you. I think I get it now. Let me fix the areas and the supervisor issues and I'll repost the structure.

Ok I've eaten and had a nap and I think I found my brain still sleeping in my bed when I got home. LOL!!! I think I understand the concept of having to use the junction table to assign the subs to the areas, however I still have no idea how junction tables work. The wiki link you provided...

Sorry, I apparently left the house without my brain this morning. I guess i was confused cause I wasn't sure how that would work using a query to look up from and populate a table field. But I think I understand it now. I'm still in a fog about the area thing, though. I think it's a mental...

So for the administrative staff i need to make a query that only returns those staff members and then use that for my look up field? I'm confused.

I'm sorry. I'm feeling rather stupid at the moment and I'm not trying to be obtuse but I'm just not getting the logic behind the junction table for the areas. It seems like an overly cumbersome way of dealing with something that I just need to have a simple yes or no checkbox for. I only need to...

I need to be able to edit almost everything in this database after it's in. Yes the area supervisor (and other supervisory positions) could change later. As could employee assignments to the different programs. Anything and everythign can change at a moments notice around here. Initially...

The row source code for the look up field is as such: SELECT [tblEmployees].[RowID], [tblEmployees].[LastName], [tblEmployees].[FirstName], [tblEmployees].[MI], [tblEmployees].[Title] FROM tblEmployees ORDER BY [LastName], [FirstName]; Is there a way to add a FILTER BY [Title]"Area...

The "area" is only for use with Substitutes...so not all employees will have areas to deal with. Let me see if I follow along with how this should work. I make a value list field in tblSchools called "Area"...remove the area fields from tblEmployees and then later on make a junction table to...

I have commented all the fields. I have also attached budget code look up fields to the tblPrograms so that the budget codes for reg wages and overtime wages are now attached to the programs. If I'm doing this right, I should end up with multiple rows for each school in the tblprograms. I...