Is it always a perfect match by date?
If you enter 1/1/2011 in the global field, will there always be a record for that account with the same exact date or might it be a date that is a few days different? (In this example 1/1/2011 falls on Saturday, so the nearest date might be 1/3/2011--the following Monday.
Either way you can set up a relationship to match by specified date and accountNo, but if there's any chance the specified date in the global field won't match to any record in your table, the relationship will need some modification in order for it to work.
Assuming a perfect match by date:
OtherTable::globalDate = Accounts::Date AND
OtherTable::AccountNo = Accounts::AccountNo
Then, if you enter 1/3/2011 into OtherTable::globaDate, Accounts::Balance will give you the balance on that date for the account specified in OtherTable::AccountNo.
Yes, it will always be an exact match.
Thank you. It worked.