Multiple of the same field on the a form

[Will G]

I am new to this database stuff and i am creating this form that will contain
many fields of the same. the database is for manufacturing beds from start to
end. tbls that i have: Model(fields: ModelNumber, Desc), Quilt(Quilt, Cost,
VendorID), Uphlsters(Uph, cost, vendor), ModelQuilT(BedQuiltID, ModelNumber,
Quilts), ModelUpholsters(BedUphID, ModelNumber, Uph)......now i want to
create a form that will contain multiple instances of QUILTS AND UPH and A
field of ModelNumber. How can i go about to create this form?

 

[John W. Vinson]

I am new to this database stuff and i am creating this form that will contain
many fields of the same. the database is for manufacturing beds from start to
end. tbls that i have: Model(fields: ModelNumber, Desc), Quilt(Quilt, Cost,
VendorID), Uphlsters(Uph, cost, vendor), ModelQuilT(BedQuiltID, ModelNumber,
Quilts), ModelUpholsters(BedUphID, ModelNumber, Uph)......now i want to
create a form that will contain multiple instances of QUILTS AND UPH and A
field of ModelNumber. How can i go about to create this form?

You can use a Form based on your Model table, with a Subform based on
ModelQuilt (using ModelNumber as the master/child link field), and
another subform based on ModelUpholsterers; if each Subform is a
continuous form, you can see multiple quilts or multiple upholsterers
at the same time.

John W. Vinson [MVP]

 

[Will G]

Hey John,
thanks for your help. but like i told you i am very fresh to this. my main
table has the modelnumberID, ModelNumber, Desc, SpringID, QuiltID, UPHID,
.....SO ON....

TABLES List
1. Bed(ModelNumber, Desc, SpringID, QuiltID, UPHID), Spring(SpringID, Cost,
Vendor), Quilt(QuiltID, Cost, vendor), UPH(UPHID, COST)
2. BedQuilt(BedquiltID, ModelNumber, QuiltID), BedSpring(BedSpringID,
ModelNumber, SpringID), BedUPH(BeduphID, modelnumber, uphID)

when i create a form using the wizard base on table BED, i get all these
fields on the form, in ID form not in the actual Spring selection
....e.x....xp203, i get instead a list of 1..2..3...s. and i assume that is
because i have the fields set like that in the Bed table. how can i go about
that John? and all i want is a form that shows, ModelNumber in a combo box
for selection, Spring in a combo box, Quilt in a combo box, another Quilt in
a combo box, another Quilt if i want to, and same for UPH

and when it comeS to creating a subform from my joint tables..which are
BedQuilt, BedSpring, etc.....all i get is a table like form......MAN, I NEED
HELP WITH THIS...I AM LOST AND IT'S JUST THE BEGINNING.
THANKS MAN.