In Base, is it possible to have one form look at two tables?

I have two tables, joined at their common field. I have a form I’ve spent a lot of time designing. I finally figured out how to make that form see either of my two tables, but I want to look at fields from both tables, at the same time. The instructions I’ve found on how to add a subform to my form are totally incomprehensible to me, and I’m not even sure that would solve my problem if I could figure out how to do it. I went back and designed a plain vanilla form from scratch, and added a subform to it in the initial design process, but then I find that I can’t (don’t know how to) add a formatted field to the subform. What I really want to be able to do is edit my form by adding formatted fields from both tables. Is that possible?

OK. So I get to answer my own question again. This one really took some work … lots of trial and error. I don’t know if the only way to set up a subform in an already existing form is to use the Form Navigator, or not, but it is one way. As counter intuitive as I found it to be, I did finally figure it out. With my form open in edit mode, I pressed F5 and Navigator came up and I have no idea what it is for. But on the design tool bar, there is an icon for Form Navigator (Navigator and Form Navigator are NOT the same thing). When I looked more closely at Form Navigator I saw that it shows Forms with MainForm under that, and under MainForm is listed all the fields, and their labels (lbl means label) and clicking on any of these listings selects or highlights the corresponding field (or label) on my form. Right clicking on a listing selects that field AND brings up a dialogue box with several choices, one of which is properties. On a hunch (or in sheer desperation) I right clicked on the top listing (Forms) and saw a choice for New! Bingo! That’s where to create the subform, which will appear below the MainForm (both of which can be renamed if desired), and fields opened on the Form can now be directed to look at either of the tables, by using the listing in the Form Navigator to select properties for that field. Simple, huh? Simple, maybe, but not very intuitive or well documented, I would say. Anyway, there is a lot more for me to learn, but THIS question, at least, I have found the answer (or an answer) to. I’m submitting this answer in case anyone else may possibly find it helpful.

1 Like

Or you could have read the documentation :
link text

page 103 and onwards