Skip to main content

Page designer using elements from 2 tables

  • February 19, 2020
  • 6 replies
  • 51 views

Forum|alt.badge.img+1

I need to create a page with elements from 2 tables. Is there a way to do that? Or multiple blocks in one page???

6 replies

  • Participating Frequently
  • February 19, 2020

Can you be more specific? If the records on both tables are linked, then you can, otherwise I don’t believe there is support for info from 2 tables


Forum|alt.badge.img+1
  • Author
  • Known Participant
  • February 19, 2020

Can you be more specific? If the records on both tables are linked, then you can, otherwise I don’t believe there is support for info from 2 tables


I have 2 fields in Source table: mission and logo.

In another table, Kids, that I’m using in Page Designer, I want to display mission and logo from Source table.
So… if I link those 2 fields to 2 new corresponding fields in Kids table, and do a @lookup to match Kids Source field with Source table fields, would that do it?

I have 4 source records, and 160 Kids records, each assigned to a source


  • Participating Frequently
  • February 19, 2020

I have 2 fields in Source table: mission and logo.

In another table, Kids, that I’m using in Page Designer, I want to display mission and logo from Source table.
So… if I link those 2 fields to 2 new corresponding fields in Kids table, and do a @lookup to match Kids Source field with Source table fields, would that do it?

I have 4 source records, and 160 Kids records, each assigned to a source


If you want to create a page for each Source that lists all the related Kids, you’d want to have a Link to Record field that connected each Kid to a Source. Then, on your page (based on Source), you can insert a table with the related Kids


Forum|alt.badge.img+1
  • Author
  • Known Participant
  • February 19, 2020

If you want to create a page for each Source that lists all the related Kids, you’d want to have a Link to Record field that connected each Kid to a Source. Then, on your page (based on Source), you can insert a table with the related Kids


Nope… one page per kid, with mission and logo from Source table. Each kid record includes their source.


  • Participating Frequently
  • February 19, 2020

Nope… one page per kid, with mission and logo from Source table. Each kid record includes their source.


Ah then you’d still have the same connection, but with the Page reversed (do pages by Kid). Think you were on the right track with your lookup fields being the easiest method


Forum|alt.badge.img+1
  • Author
  • Known Participant
  • February 19, 2020

Ah then you’d still have the same connection, but with the Page reversed (do pages by Kid). Think you were on the right track with your lookup fields being the easiest method


now all I have to do is figure out how to do that!!!

Thanks, Nick