Originally Posted by
ssanfu
I only use saved queries or SQL strings for forms/reports. So I created a saved query based on the table tblApplicants and set that to be the record source for the form frmApplicants.
Using a query makes it real easy to limit the number of fields used and/or the number of records displayed (filtering).
It looks like frmApplicants should have two sub forms - a sub form for Assessing_ERIS and a sub form for OnboardingERIS.
Awaiting your comments.....
OPk so basically the query becomes the entry for the form? I'm not sure I understand. I had to edit the SQL just a tad as it was missing "tbl" from in front of Applicants on the FROM line. Once I did that I was getting pop-ups for parameters for each field in the query. So I guess it is working as designed.
Code:
SELECT Applicants.ApplicantsID_PK AS Expr1, Applicants.SSN AS Expr2, Applicants.LastName AS Expr3, Applicants.FirstName AS Expr4, Applicants.Gender AS Expr5, Applicants.Ed_Code AS Expr6, Applicants.AFQT AS Expr7, Applicants.Status AS Expr8, Applicants.[Q_I Date] AS Expr9, Applicants.MEPS_Date AS Expr10, Applicants.[MEPS _Count] AS Expr11, Applicants.DEP_Date AS Expr12, Applicants.Ship_Date AS Expr13, Applicants.Program AS Expr14, Applicants.Reclass_Date AS Expr15, Applicants.Attrite_Date AS Expr16
FROM tblApplicants;
In respect to continuing the relationship chain would I connect that data like this:
I am relooking at it from another angle for normalization. Your articles helped and I have read a bit more. So I am taking another look to see if there is a better way. Thanks.