I have a purchase order table. As I need to select either a surveyor or drafter before creating a PO, I need to be able to populate relevant vendor number. Currently I have a field with multi choice for surveyor and drafter. But no too sure where to keep vendor numbers matching surveyors. Is there an easy way that my vendor field is auto populated without creating one more table. But if I do need to add a table, what is the process to match up a field in PO table with vendor number. Should i keep surveyor or vendor in the other table to facilitate drop downs? Will appreciate some help.