More than one record per record on a form...

[Robin S.]

More clueless newbie questions...

Table 1: "available specs"

Table 2: "classes"

A single form shows a single record from the table "classes". Each record in
"classes" may contain several records from "available specs" (and several
fields from each of those records).

I have no idea how to display all the fields from each record in "available
specs" for several different "available specs" records, all on the same
form.

I have the text "How to do everything with Access 2002" by Anderson. I think
I may need to upgrade...

Thanks for any help.

Regards,

Robin

[Salad]

"Robin S." wrote:

More clueless newbie questions...

Table 1: "available specs"

Table 2: "classes"

A single form shows a single record from the table "classes". Each record in
"classes" may contain several records from "available specs" (and several
fields from each of those records).

I have no idea how to display all the fields from each record in "available
specs" for several different "available specs" records, all on the same
form.

I have the text "How to do everything with Access 2002" by Anderson. I think
I may need to upgrade...

Thanks for any help.

Regards,

Robin

If I understand you question correctly....

Normally you would create 2 forms; 1 for classes, the other form for specs. The
form for Classes could be a single form. Then create a form for specs. This
could be a Continuous Form (see the data tab)

Now open up the form Classes in design view. From the Toolbox toolbar, select
SubForm. You will be prompted to present the link between the two tables.
Let's say you have a field called "ClassID" in both tables. You would use that
field as the link.

Now save the form then run it. Change the field presentation to suit your input
needs.