Dispalying records from 2 unrelated tables in the same layout

[Carri]

Hi

I have 2 identical databases being used by 2 different departments. (Don't ask that's what they want)

For explanation purposes both DB's have an identical table named PROGRAM

Is it possible to display the records from both PROGRAM tables in the same layout in one of the DB's?

Thanks Again

[mz123]

You could if you had a layout with two portals next to each other... not sure if there is any way to put both sets of records in one list view though.

[bcooney]

Depends on what you mean. A layout only shows records from the table (occurrence) upon which it's based.

However, you could show a portal of related records. So, if you have a third table, let's say "SYS" which only has one record, you could create a layout based on SYS. Create two new relationships. The first is SYS to PROGRAM1 using the "x" operator to show all records. The second is the same to PROGRAM2.

Then, put two portals on the layout (perhaps in their own tab panel or side to side). One portal for one PROGRAM table and one for the other using the relationships you created above.

But this is just guess-work. If you want to combine the records, create a table and import from both sources into a "reporting" table.