This is a beginner’s question. I'm trying to create a form with a subform in order to perform data entry. What I would like is the subform to also have some info from other tables. Apparently in order for access to do that it changes the controlsource of the subform from a field of the subform table to a query. When doing so though I can't perform the data entry needed.
i.e. I have the table multicase and the subtable multicaseitems. The form multicase has a field that I can use to type a multicase ID and with the subform I want to add Case IDs (combobox with row source from the cases table). So far so good. If I use “add existing fields” to add fields from different tables like casedate that comes from a different table, they can’t be added. If I switch to design view of the subfrom and do the same I can add them but the subform wont add rows. key fact is that I dont need to update the values of the other tables, it's just to be viewed.
Is there any way to tackle this?
thanks!