AnsweredAssumed Answered

related tables with lookup (conditional)

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

Title

related tables with lookup (conditional)

Post

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

 

Thanks

 

Geof

 

Outcomes