How to show the Supplier Address

Hi all expert,

I have create a List named as Supplier. In the list got 3 fields - Supplier
Code, Supplier Name, Address. I have save few supplier record in the list.
After that, i create a new List called as Product Supplier. In the list got
some fields such as - Product Code, Product Name, Price, Supplier Name,
Address.
Product Code and Product Name are blank fields, but the Supplier Name is a
drop down list and will shown the Supplier Name from the Supplier List. It's
work fine. But i facing a problem to show the Supplier Address after i select
the supplier in the Supplier Name drop down list. Mean if i select Supplier
Name - ABC, then i want the Supplier Address show the ABC company address in
another address label in row below the Supplier Name.
Can anyone tell me, is it this problem can be solve?
What is the step i need to do for this problem?
Thanks in advance for your kindy help...

Amir
Wed Apr 23 01:33:32 CDT 2008

I think you need connected web part. Create a page put two web parts in that
page and connect them together. By using connected web parts you can filter
value of one web part based on value of other web part.
On web part click Edit then choose connection. One web part (for your sample
is suppliers) is data provider and another one is reciever.

--
Amir Mehrani
http://sharepointroad.wordpress.com

"bey" <bey@discussions.microsoft.com> wrote in message
news:65B78C24-C3F1-45F6-968D-DABF9860B114@microsoft.com...
> Hi all expert,
>
> I have create a List named as Supplier. In the list got 3 fields -
> Supplier
> Code, Supplier Name, Address. I have save few supplier record in the list.
> After that, i create a new List called as Product Supplier. In the list
> got
> some fields such as - Product Code, Product Name, Price, Supplier Name,
> Address.
> Product Code and Product Name are blank fields, but the Supplier Name is a
> drop down list and will shown the Supplier Name from the Supplier List.
> It's
> work fine. But i facing a problem to show the Supplier Address after i
> select
> the supplier in the Supplier Name drop down list. Mean if i select
> Supplier
> Name - ABC, then i want the Supplier Address show the ABC company address
> in
> another address label in row below the Supplier Name.
> Can anyone tell me, is it this problem can be solve?
> What is the step i need to do for this problem?
> Thanks in advance for your kindy help...
>