Lookup from two seperate tables using 'if'?
I have a database with two related tables (A + B) containing client details. My invoicing database has a lookup from table A to copy address details across. Occasionally I need it to lookup from Table B - is this possible if I use a calculation somehow? How and where would I implement it?