Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple subreports

Status
Not open for further replies.
MsJami

MsJami

Technical User
Sep 1, 2004
29
0
0
US
Hi,
I have 3 tables all linked by subcontractid, subcontracts is my main table, subchangeorders is another and subinvoices is another.
I want to have a form with these three tables as subforms. But I can only do subcontracts and subchangeorders, or subcontracts and subinvoices.
Any suggestions would be greatly appreciated.
Thanks in advance
Jami
 
Sort by date Sort by votes
'I want to have a form with these three tables as subforms'
?All three?

What is the main form based on then?

 
Upvote 0 Downvote
OOps I have also have a table that lists all the subs and that is actually the main form then the three would follow they also have a subid.
Jami
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Create multiple reports 1
2 3
Replies
47
Views
223
TrekBiker
TrekBiker
meagain
  • Locked
  • Question
DLookup with Multiple Criteria 1
Replies
3
Views
74
Andrzejek
Andrzejek
misuser2k7
  • Locked
  • Question
Wild card search on combo box with multiple rowsources
Replies
1
Views
39
MajP
MajP
roystreet
  • Locked
  • Question
Simple Way To Related Multiple Records To Multiple Records
Replies
2
Views
34
Andrzejek
Andrzejek
DSaba10
  • Locked
  • Question
Creating a form to handle insert multiple ids into a single table 1
Replies
6
Views
60
DSaba10
DSaba10

Part and Inventory Search

Sponsor

Back
Top