Basically I have a database added to my project, and I need to know how to make a column map to another table.

I have attached a couple of screenshots to show you what I mean, I want the "Absences" to be a new table, instead of a single DateTime.

Attachments 8.png 26.29 KB 9.png 72.45 KB
7 Years
Discussion Span
Last Post by Mitja Bonca

So create a new table, and inside of it create some columns: AbsenceID, StudentFK, Date.
This means each row will have its only id (primary key), foreign key to the Students table, and an actual absendce date.
So you will have this kind of structure:

Student: StudentID, Name, Age,... (and no Absence)
Absence: AbsenceID, StudentFK, AbsenceDate

Edited by Mitja Bonca: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.