Hi All
I inherited an Access database that was so bloated it was hard to use. The basic structure is biographical information than the different projects my company does. What I inherited had everything in one table and it took forever to load.
So, I thought it would be a good idea to create a new table for each program and one table with all the bio info. The programs all have the same info, date - location - time - notes.
What links the program tables to the bio table is a unique number that acts as our employee numbers. What I wanted to do was create a relationship based on those numbers.
I then create a query to link the biodata to the project data, the query works but then I error that the records are not updateable. I really hope I didn't spend all this time for it not to work.
This is the SQL and my query built is attached
SELECT tblPrimaryTable.Status2, tblPrimaryTable.[Orienation Date], [tbl90-Day].[90 Day Status], tblPrimaryTable.FirstName, tblPrimaryTable.LastName, tblPrimaryTable.[Specialty Department], tblPrimaryTable.[Transition Date], [tbl90-Day].[90 Day Check-In Date], [tbl90-Day].[90 Day Location], [tbl90-Day].[90 Day Time], tblNotes.[90 Day notes]
FROM tblSchedulingStatus INNER JOIN (tblNotes INNER JOIN ([tbl90-Day] INNER JOIN tblPrimaryTable ON [tbl90-Day].NUID = tblPrimaryTable.NUID) ON tblNotes.NUID = tblPrimaryTable.NUID) ON tblSchedulingStatus.[Scheduling Status] = [tbl90-Day].[90 Day Status]
WHERE (((tblPrimaryTable.Status2)="Staff"));
I hope it is a simple thing I need to do. Please let me know if you need any more information and I appreciate your help.
I inherited an Access database that was so bloated it was hard to use. The basic structure is biographical information than the different projects my company does. What I inherited had everything in one table and it took forever to load.
So, I thought it would be a good idea to create a new table for each program and one table with all the bio info. The programs all have the same info, date - location - time - notes.
What links the program tables to the bio table is a unique number that acts as our employee numbers. What I wanted to do was create a relationship based on those numbers.
I then create a query to link the biodata to the project data, the query works but then I error that the records are not updateable. I really hope I didn't spend all this time for it not to work.
This is the SQL and my query built is attached
SELECT tblPrimaryTable.Status2, tblPrimaryTable.[Orienation Date], [tbl90-Day].[90 Day Status], tblPrimaryTable.FirstName, tblPrimaryTable.LastName, tblPrimaryTable.[Specialty Department], tblPrimaryTable.[Transition Date], [tbl90-Day].[90 Day Check-In Date], [tbl90-Day].[90 Day Location], [tbl90-Day].[90 Day Time], tblNotes.[90 Day notes]
FROM tblSchedulingStatus INNER JOIN (tblNotes INNER JOIN ([tbl90-Day] INNER JOIN tblPrimaryTable ON [tbl90-Day].NUID = tblPrimaryTable.NUID) ON tblNotes.NUID = tblPrimaryTable.NUID) ON tblSchedulingStatus.[Scheduling Status] = [tbl90-Day].[90 Day Status]
WHERE (((tblPrimaryTable.Status2)="Staff"));
I hope it is a simple thing I need to do. Please let me know if you need any more information and I appreciate your help.
Attachments
Last edited:
