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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Different record source for Header, Detail, Footer

Status
Not open for further replies.
jodjim

jodjim

Programmer
Nov 5, 2004
69
CA
I want to create a form with Header data coming from Table 1, Detail from Table2, and Footer from Table 3. The tables share the same ID field. What is the best approach to do this?

Thanks.
 
Sort by date Sort by votes
Option1 sub report
option2 query containing info from 3 tables
option3 dlookup
 
Upvote 0 Downvote
Thanks gol4. I use option2 with variation since each table has different set of data.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
626
dhookom
dhookom
TechieJr
  • Locked
  • Question
Filtering for null or empty field
Replies
8
Views
1K
dhookom
dhookom
qqp
  • Locked
  • Question
Looking for ideas on how to create an estimating form that would have a header and details under it 1
Replies
2
Views
385
qqp
qqp
BallunarCrew
  • Locked
  • Question
Looking for a color chart 1
Replies
2
Views
312
BallunarCrew
BallunarCrew
DB_Bowes
  • Locked
  • Question
Selection from Listbox to GoTo Record in Bound form Gives Error 2105
Replies
1
Views
356
DB_Bowes
DB_Bowes

Part and Inventory Search

Sponsor

Back
Top