AnsweredAssumed Answered

Lookup from two seperate tables using 'if'?

Question asked by gavjuan on Sep 17, 2013
Latest reply on Sep 19, 2013 by philmodjunk

Title

Lookup from two seperate tables using 'if'?

Post

     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?

Outcomes