Switching the order of main forms and subforms

D

DianeH

I'm using Access 2003. I understand that the main form is on the one side of
a 1 to many relationship and the subform is on the many side of the
relationship. Is it possible, however, to switch this around if the records
from the main table are read-only? For example:

Courses Table (one record to many records in the Classes Table)
Classes Table (many records relating to Courses Table with varying dates,
locations, presenters, etc.)

I would like to allow the user to browse through the classes and have the
related Course information show in a tab, but I haven't been able to find a
way to do that.
 
K

KARL DEWEY

I would like to allow the user to browse through the classes and have the
related Course information show in a tab,
You can use a single for to do this by joining the tables in your query that
feeds the form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Value Does Not Display in Form (but will in table) 1
filtering a form based on the values of a subform 0
Subforms 6
Main Form with Subforms 5
Error When Entering Data in a Subform 4
Form not carrying names to table behind the subform. 7
odd subform which is on the one side of a one to many relationship 12
Type mis match in expression on a form 2

Top