how to join two dbs into one - brain death!

[toy]

hey all

i seem to be having this mental block

how can i have one db C which is a listing of all records in db A and db B

sorted by date and time (which are the common fields to both A and :

pls help

this should be easy, no??

my brain just isnt happening on this

[leahbrooks]

You could export the records from A & B into C. But otherwise, you'd have to have two relationships, and couldn't sort them all together.

[McCormick]

If you're still working on this ...

dbC is related to both dbA and dbB through some field or other. I'll call it AorB, and simplify that its only values are "UseA" and "UseB".

Add a new field to dbC that is a calculation:

If(AorB="UseA", A::date, B::date) where it looks up the answer through the appropriate relationship. This spits out a date either way, and you can sort by that field.

If there are more than two possibilities, use a Case structure instead of If.