related tables with lookup (conditional)
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