base: how to make a form that relates to different possible tables

[Juan]

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!

[Ratslinger]

In direct answer to your question, you can hide/reveal different controls dependent upon a selection(s) using macros. Some samples of this can be seen in links here (follow link in comment) and here (samples here are “tabbed” forms but concept is exactly the same).

However, your description seems vague and may have some potential problems/considerations. For example, if you set type to “dance” then create a subtable record and later change type to “music” how are you to handle the subtable record for “dance” previously created? You must also consider when creating the main table record, it should be added to the table before attempting the subtable record. I can envision many other hurdles to overcome.