Please see campus table. Tried to save after setting both foreign keys with primary symbol, then a null value error occurs when trying to save object. Database attached.
Thank you to anyone who can help.
Competent Performer
Windows XP 
Access 2010 32bit
Please see campus table. Tried to save after setting both foreign keys with primary symbol, then a null value error occurs when trying to save object. Database attached.
Thank you to anyone who can help.
VIP
Windows XP Access 2010 32bit
A student can have only one advisor? A student and advisor can each have only one campus/department? A junction table is not need. You need a table of campus and departments. Then field in tblAdvisor for the department/campus ID. Student associates with advisor and advisor associates with campus/department.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Setting NOT NULL for an column
Posting Permissions
Reply With Quote