G
Guest
IN MS Access Query Design Mode
We have 2 tables
Table-1 Supplier Table with Full Address – Mutlifields (Name, Address,
email etc)
Table-2 Short Title Supplier –Single field
Example1) Sony International, Sony Local, Global Sony, J-Sony-Singapore as
supplier name in Table A
2) Pepsi Holdings, Pepisico, Singapore Pepsi as supplier name in Table 2
These 2 companies have short names as Sony, Pepsi in Table 2.
Using MS Access Query in Design Mode , how do I link these 2 tables and
extract data from Table-1 for Sony, Pepsi
My search normally at a time is to look for data in Table-1 for 50 Short
name suppliers.
Any help will ge greatly appreciated.
We have 2 tables
Table-1 Supplier Table with Full Address – Mutlifields (Name, Address,
email etc)
Table-2 Short Title Supplier –Single field
Example1) Sony International, Sony Local, Global Sony, J-Sony-Singapore as
supplier name in Table A
2) Pepsi Holdings, Pepisico, Singapore Pepsi as supplier name in Table 2
These 2 companies have short names as Sony, Pepsi in Table 2.
Using MS Access Query in Design Mode , how do I link these 2 tables and
extract data from Table-1 for Sony, Pepsi
My search normally at a time is to look for data in Table-1 for 50 Short
name suppliers.
Any help will ge greatly appreciated.