Jump to content
Sign in to follow this  
toy

how to join two dbs into one - brain death!

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.