Hi
I have a database with a number of tables set-up with primary keys etc. Is it possible when entering a value into one table to get it to also automatically add/show some of the data from the other tables without having to use a query?
Ie I have table one that shows employees. In another table I have tasks. I would use the primary key of the employee in tasks but is it possible to get it to show the primary key and the name or does that just defeat the point of normalisation?