Hello! I have a main table where I want to include files and a category called ‘type’. If 'type’s is ‘dance’ then I want to fill in information in another table called Dance. If ‘type’ is interview then I need the form to change to fill in information in the Interview Table (such as interviewer, interviewee, date of interview, etc). If 'type’s is ‘music’ then I fill in the music table info such as musician name and their instrument.
Can I have one single form changing depending on the value of ‘type’ so that I fill in the subtable I need? (that is, dance, interview or music).
Thank you!