Any better approach to link supplier name with sales table brand field ?

[Paulyeo11]

Hi All

My sales Table have field name = BRAND_C , one of the value label = REDLOIN :-

My Supplier Table have a Supplier name = REDLION

Normal my approach is i create a extra table , which have below field :-

BRAND_C......SUPPLIER

REDLION.......REDLION CONTROLS IINC

And create a link field to link supplier name from supplier table and sales table brand_c field. 

May i know it there any short cut ?

Paul

[parry2k · Accepted solution]

@Paulyeo11 it is the right approach, basically, you are creating a bridge table to link everything together.