8 Replies Latest reply on Sep 19, 2013 11:36 AM by philmodjunk

    Lookup from two seperate tables using 'if'?

    gavjuan

      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?