Ask Your Question

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

asked 2016-11-19 21:00:42 +0100

Juan gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-15 19:00:27.253142

1 Answer

Sort by » oldest newest most voted

answered 2016-11-19 23:21:06 +0100

Ratslinger gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-11-19 21:00:42 +0100

Seen: 62 times

Last updated: Nov 19 '16