Newbies toy Posted June 6, 2003 Newbies Share Posted June 6, 2003 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 Link to comment Share on other sites More sharing options...
leahbrooks Posted June 6, 2003 Share Posted June 6, 2003 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. Link to comment Share on other sites More sharing options...
McCormick Posted June 13, 2003 Share Posted June 13, 2003 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7616 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now