AnsweredAssumed Answered

related tables with lookup (conditional)

Question asked by GeofreyDeVisscher on Sep 30, 2014
Latest reply on Oct 29, 2014 by philmodjunk


related tables with lookup (conditional)


Dear all,


I am quit new at this but created a few databases we use as a group. I have created a general contact database which I am lining to other databases. For ordering I would like to create another table linked to the contacts but that automatically contains only the suppliers so I can link it t our orders database. I have tried the related tables with lookups but I seem not to get it right. The closest I got was to a lookup that only copied the first supplier repetitively.

Any tips? Thanks in advance