Hi
Tables
Hospital
HospitalSysID
HospitalName
HospitalDept
HospitalDeptSysID
DepartmentName
Hospital_HospitalDept
Hospital_HospitalDeptSysID
HospitalSysID
HospitalDeptSysID
Log
must I use Hospital_HospitalDeptSysID or HospitalDeptSysID
with Foreign Key on ??
I want the DepartmentName to display in Log Form and Browse