I have 2 tables, lets call them Company and employees, i can add notes to both views that are linked to the Company ID or Employees ID, each of these tables have a column called Status, when i create a new note i would like it to fill that status in to the note table but as i have 2 parent i cant just use the normal ref, is there a way to say, take Status from PARENT and put it here?
LinkedIn
Twitter
