ChemFinder: I have a form with a subform, but when I switch to Table view, I don't see the information in the subform.

I have a form with a subform, but when I switch to Table view, I don't see the information in the subform.

You can make a query that flattens out the two tables the form and subform are based on. If the MOL_ID from the MOL_TABLE is in the query, when you look at the query you see the Structure field just as if you were looking at the MOL_TABLE itself. What this means is that you can build forms bound to queries and do everything structure-wise with them that you can do with forms bound to tables.