hello everyone. i'm a newbie to ms sql but i understand the basics of adding tables and linking them. i have two tables tables that i have linked; Department and Employee. The Department table is the main table with a foreign key in the Employee table.
now from by basic understanding, if i'm to input data into the Department table and then input data in the Employee table, the foreign key 'Department_id' in the Employee table should automatically fill up, right?
well it keeps telling me that i can't leave that field null, but i can't manually fill in the data too. what am i doing wrong. can anyone help?