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

creating Multiple subforms

P: n/a


I am trying to add multiple subforms (or subtables?) on an existing
form. The underlying table is a very detailed descriptive table for art
in a collection. I am already using one subtable to manage the movement
in and out of inventory. When I look at the table in the datasheet view,
I see the "+" sign next to each record, and when I click on that, I see
the subtable I already have setup - looking at that, it seems impossible
to have more than one subtable... is this true? This does not seem
right.

My question is this:
Can I have more than one subform in a given form? What I would like to
have is a subform to keep track of provenance for any given piece
(history of ownership), and another to track appraisals (values, dates,
appraiser, etc) of any given piece in the collection.

Are there any samples of what I am trying to do?
*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Yes, you can have multiple subforms. Your tables should look like:
TblArtPiece
ArtPieceID
<descriptive fields>

TblProvence
ProvenceID
ArtPieceID
<owner fields>

TblAppraisal
AppraisalID
ArtPieceID
<appraisal fields>

Your main form would be bases on TblArtPiece and you would have two
subforms. The first based on TblProvence and the second based on
TblAppraisal.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!


"Guy_Philly" <ju***@loveconsulting.com> wrote in message
news:kZ***************@news.uswest.net...


I am trying to add multiple subforms (or subtables?) on an existing
form. The underlying table is a very detailed descriptive table for art
in a collection. I am already using one subtable to manage the movement
in and out of inventory. When I look at the table in the datasheet view,
I see the "+" sign next to each record, and when I click on that, I see
the subtable I already have setup - looking at that, it seems impossible
to have more than one subtable... is this true? This does not seem
right.

My question is this:
Can I have more than one subform in a given form? What I would like to
have is a subform to keep track of provenance for any given piece
(history of ownership), and another to track appraisals (values, dates,
appraiser, etc) of any given piece in the collection.

Are there any samples of what I am trying to do?
*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #2

P: n/a

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:OC****************@newsread1.news.atl.earthli nk.net...

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You only care about making money, and you act as if the groups are your private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
************************************************** ******
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!


Need a psychiatrist ...Contact me!

Arno R

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.