Linking multiple fields in one table to single field in another?

[mapratt82]

So I'm needing to link a table that has "Primary", "Secondary", and "Tertiary" users back to the "UserID" in the User table. How can I accomplish this? Thanks in advance!

[Anonymous]

Hi Sunny,

Vendor ID	Vendor Name	Diverse	Lookup Type
	Abc	US	Vendor Name
	def	US	Vendor Name
	qww	US	Vendor Name
	ert	US	Vendor Name
	tyu	US	Vendor Name
	yui	US	Vendor Name
	iop	US	Vendor Name
	rgf	US	Vendor Name
	ujy	US	Vendor Name
	mjh	US	Vendor Name
	xcv	US	Vendor Name
	iog	US	Vendor Name
60054	HFHGB	UK	Vendor Id
605391	Esurt	UK	Vendor Id
605719	Ecoce	UK	Vendor Id
600559	mited	UK	Vendor Id
605625	3Sing Ltd	UK	Vendor Id
60548	4litd	UK	Vendor Id
605673	affg	UK	Vendor Id
645581	ATABLE	UK	Vendor Id
700105	A.Scitors	UK	Vendor Id

I want this file to be linked with data model like where there is a vendor ID then all the records with Vendor Id should be picked and where there is no Vendor Id then records should be picked with Vendor Name.

Corresponding fields in my data model are:

vendor Id->Global Supplier

Vendor Name-> Supplier Name

Can you help?

Thanks.