Showing records from two db's in one portal?

[Ross Scholes]

Depends on the eventual mechanism you intend for analysing your data.
If it means combining similar types of data into sets and sorting for
comparison, then you might try creating a third file [Master] (e.g.. via
cloning) and setting it up with import routines/ scripts. There are data
integrity issues to be dealt with but most basically ...

[REFRESH]: script in Master
Show All Records
Delete All Records
Perform Script | External Script (Slave_1, [xtREADY])
Perform Script | External Script (Slave_2, [xtREADY])
Import (Slave_1) [no dialog]
Import (Slave_2) [no dialog]
Sort ... etc.

[xtREADY]: script in Slave_1, Slave_2, ...
Freeze Window
Show All Records ... or ... Find [Restore the subset(s) of interest],
etc.
Toggle Window [minimise]

Scripted import\ export encompasses MUCH scope for bulk data management.

Ross Scholes

[tester]

This would solve a HUGE problem for our school.

Our school transcript database shows all classes completed in our
school.

I have a seperate databse with classes completed in other schools.

How can I create one portal to show the information from both databases?

Is there a different approach?

This would allow our registrar to quickly check what courswork remains
to be done. [something I hope to get FM to do someday, I would have to
compare a list of specific classes needed with actual classes completed
[if someone can get me on the rihght track for that, it would be a
bonus!]]

[Bridget Eley]

You can't actually display records from two databases in a single portal,
but there is no reason why you can't display two portals on a single layout,
then create calc fields to summarise the data in each (eg total credit
points awarded), eg calc (number result) = Sum (relationship::field). Add
the results in a third calc to show total earned to date. In another calc,
you could subtract them from total credit points required to show total
still required. These calc fields can be displayed on any layout where that
information is needed, with or without the portals (although be wary of
putting them in a list or table view).

Bridget Eley

in article 091020031324351585%martinc6868@yahoo.com, tester at
[email]martinc6868@yahoo.com[/email] wrote on 10/10/03 6:24 AM:

> This would solve a HUGE problem for our school.
>
> Our school transcript database shows all classes completed in our
> school.
>
> I have a seperate databse with classes completed in other schools.
>
> How can I create one portal to show the information from both databases?
>
> Is there a different approach?
>
> This would allow our registrar to quickly check what courswork remains
> to be done. [something I hope to get FM to do someday, I would have to
> compare a list of specific classes needed with actual classes completed
> [if someone can get me on the rihght track for that, it would be a
> bonus!]]

--

(to email direct, replace "DOT" with "." and remove ".invalid")