Sorry, we don't support your browser.  Install a modern browser

Display data from two columns in relational database#416


What would be useful is to be able to display two columns from one table into a second table using ralational database / foreign key.

E.g. Using the example provided on relational databases where table 1 contains employee details - name in one column and date of birth in another column. Then table 2 contains rota information where you can select an employee from a dropdown box. What I would like to do is to choose an employee in the rota table from a dropdown box, but when selected have the corresponding date of birth stored in the employee table, displayed in a second column in the rota table.

3 months ago