creating Multiple subforms

[Guy_Philly]

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 ***

[PC Datasheet]

Re: creating Multiple subforms

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
resource@pcdata sheet.com

https://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 " <junk2@lovecons ulting.com> wrote in message
news:kZLdf.56$i P2.3217@news.us west.net...[color=blue]
>
>
> 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 ***[/color]

[StopThisAdvertising]

Re: creating Multiple subforms


"PC Datasheet" <nospam@nospam. spam> schreef in bericht news:OCNdf.8697 $m81.835@newsre ad1.news.atl.ea rthlink.net...[color=blue]
>
> 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.[/color]

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?
*************** *************** *************** ***********
[color=blue]
> Need a month calendar or 7 day calendar? Need appointment scheduling? Need
> room reservations scheduling? Need employee work scheduling? Contact me![/color]

Need a psychiatrist ...Contact me!

Arno R