Hello Orange,
It does seem possible as I've got the following SQL:
Code:
SELECT tblHIPAArelational.tblOU_ID,
tblComputer.Computer,
tblHIPAArelational.[Why Not Case Locked With Nylon Wire],
tblHIPAArelational.[Why Not Boot Only From Hard Drive],
tblHIPAArelational.tblJavaVersion_ID,
tblHIPAArelational.tblAdobeVersion_ID,
tblHIPAArelational.tblBIOSVersion_ID,
tblComputer.[MAC Address],
tblHIPAArelational.[Why Not Wake On LAN Enabled],
tblHIPAArelational.[Why Not TrackIt Installed],
tblHIPAArelational.[Why Not Workstation Manger Installed],
tblHIPAArelational.[Date Installed], tblHIPAArelational.Case_Locked_Boolean,
tblHIPAArelational.Boot_Only_Boolean,
tblHIPAArelational.Wake_On_Boolean,
tblHIPAArelational.TrackIt_Boolean,
tblHIPAArelational.Manager_Installed_Boolean
FROM (((((
tblHIPAArelational
LEFT JOIN tblJavaVersion ON tblHIPAArelational.tblJavaVersion_ID = tblJavaVersion.ID)
LEFT JOIN tblAdobeVersion ON tblHIPAArelational.tblAdobeVersion_ID = tblAdobeVersion.ID)
LEFT JOIN tblBIOSVersion ON tblHIPAArelational.tblBIOSVersion_ID = tblBIOSVersion.ID)
LEFT JOIN tblOU ON tblHIPAArelational.tblOU_ID = tblOU.ID)
LEFT JOIN tblComputer ON tblHIPAArelational.tblComputer_ID = tblComputer.ID)
LEFT JOIN tblServicePackRelational ON tblComputer.Computer = tblServicePackRelational.Computer;
The area that it seems to mess up is when I add the LEFT JOIN tblServicePackRelational ON tblComputer.Computer = tblServicePackRelational.Computer
when that's in, it doesn't let me edit. Is there anyway I can fix this? Can or does it need some other way of indexing it all? I do know that the tblComputer.Computer each have unique names and MAC addresses. So can I remake the relations so that it is based off the tblComputer entries?
Thanks