Can you show the many part of a relationship on the one form witho

[Melvis]

Here's my situation. I am working on a new data design for tracking the
reasons an application gets rejected. There was previously a paper form with
a bunch of categorized reasons. The person who originally built the database
only put in enough room for 3 categories and 2 reasons per category (for 6
total reasons).

I would like to split up the reasons into a seperate table, where there is
one reason per record. When they are viewing the review sheet, they need to
see all of the reasons the application was rejected. Is there a way to embed
a "subreport" in a form so I can show this in a formatted way, or am I
limited to datasheet subforms?

 

[LeAnne]

Hi Melvis,

Sure. Your proposed redesign makes relational sense...applications
related 1:m to reasons for rejection. I'd suggest a form-subform
configuration with the form based on tblApplications, and the subform
based on tblReasons as a continuous form. Personally, I think that
Access' OLH isn't the greatest source for information on creating &
using continuous forms (you can start with "Types of subforms" & "Set
the opening view of a form (one record, more than one, or datasheet").
You might also check some printed references such as "Running Microsoft
Access xx" (Microsoft Press) by John Viescas or "Using Microsoft Access
xx" (Que Corporation) by Roger Jennings.

hth,

LeAnne