By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,501 Members | 831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,501 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.