Displaying multiple records on a form..

[Robin S.]

I tried to ask this question several days ago, but I didn't explain my
application correctly.

Basically I want to have one record from table "A" and I want to display,
say, 5 records from table "B" which are specified by the one record from
table "A"... And all on the same form. I do not want to use a subform. The
record fields from table "B" must be displayed in text boxes with the record
fields from the single record from table "A".

The idea is that the form is a product enter form. Table "A" holds products.
Table "B" holds the different specifications which must be entered for each
product. By displaying specifications, I can guide the user to enter certain
specifications which are specific to a group of products. For instance, all
drills would have the specs: amps, volts, rpm, chuck size. Saws would have
specs like: horsepower, volts, rpm, blade size, table size.

It is a many-to-many relationship.

I just don't know how to pull more than one record from the same table on
the same form. I can design the form in Access if it would help explain my
idea (although, it would not actually function of course).

Thanks for any thoughts. I've been going over this in my mind for several
weeks now. You can tell this isn't my day job (week-end job).

Regards,

Robin

[Bob Quintal]

"Robin S." <la*******@hotmail.com> wrote in
news:m0*******************@news20.bellglobal.com:

I tried to ask this question several days ago, but I didn't
explain my application correctly.

Basically I want to have one record from table "A" and I want
to display, say, 5 records from table "B" which are specified
by the one record from table "A"... And all on the same form.
I do not want to use a subform. The record fields from table
"B" must be displayed in text boxes with the record fields
from the single record from table "A".
Robin, whether or not you want to use a subform, a subform is the
correct way to design this application.

The idea is that the form is a product enter form. Table "A"
holds products. Table "B" holds the different specifications
which must be entered for each product. By displaying
specifications, I can guide the user to enter certain
specifications which are specific to a group of products. For
instance, all drills would have the specs: amps, volts, rpm,
chuck size. Saws would have specs like: horsepower, volts,
rpm, blade size, table size.

It is a many-to-many relationship.

I just don't know how to pull more than one record from the
same table on the same form. I can design the form in Access
if it would help explain my idea (although, it would not
actually function of course).
Nobody knows, because it's not really possible, except for using
a subform. You could try to set up a list box, but you'd then
have to write tons of code to duplicate what's built into a
subform control.

Thanks for any thoughts. I've been going over this in my mind
for several weeks now. You can tell this isn't my day job
(week-end job).

Regards,

Robin

[Robin S.]

"Bob Quintal" <bq******@generation.net> wrote in message
news:83******************************@news.teranew s.com...

Nobody knows, because it's not really possible, except for using
a subform. You could try to set up a list box, but you'd then
have to write tons of code to duplicate what's built into a
subform control.

Do you mean that what I want to do cannot be done, or that it cannot be done
without a subform? I didn't really mean I don't want it used so much as I
don't want the fields displayed in the one box as in a standard subform. I
need them displayed on the mainform... Whatever means possible.

Thanks again.

Regards,

Robin

[Roger]

the only way to show more than one record on a form is to make it
tabular or datasheet

the best way to show master (product) data and detail (specification)
data is to use a subform on a form

tblProduct
productId autokey (pk)
description

tblSpecification
productId (fk)
specificationId autokey (pk)
description

tblProduct
drill

tblSpecification
amps
volts
rpm
chuck size

create a columnar form for Product, showing productId, description
create a second tabular from for Specification, showing just
description

drag the specification form undo the product form (to create a
subform) or use
the subform wizard

your form will end up with

productId: 1 description: drill

description
amps
volts
rpm
chuck size

"Robin S." <la*******@hotmail.com> wrote in message news:<Gn*******************@news20.bellglobal.com> ...

"Bob Quintal" <bq******@generation.net> wrote in message
news:83******************************@news.teranew s.com...

Nobody knows, because it's not really possible, except for using
a subform. You could try to set up a list box, but you'd then
have to write tons of code to duplicate what's built into a
subform control.

Do you mean that what I want to do cannot be done, or that it cannot be done
without a subform? I didn't really mean I don't want it used so much as I
don't want the fields displayed in the one box as in a standard subform. I
need them displayed on the mainform... Whatever means possible.

Thanks again.

Regards,

Robin