Hello to all !
I have a this scenario. I have a table(table1) with 2 fields , one is NAME and the other is NUMBER.
Now I also have an other table (table2) with many other fields and I made a form for it.
Now what I want to do is this.
Every time on the form I insert a NAME from table1 I want the field NUMBER on the form to be autofilled by the value of table1.:confused:

Can any one help me please?
Thank you for your time.

It is simple. I have attached a small sample database. The control has to be combo box. It should be populated by the names. Hope you can understand it. Cheers

It is simple. I have attached a small sample database. The control has to be combo box. It should be populated by the names. Hope you can understand it. Cheers


Thank you for your efford, But is not what I need as I can understand it.
look , I send you a powerpoint slide in order to help you understand.
AGAIN A BIG THANK YOU!

Thank you for your efford, But is not what I need as I can understand it.
look , I send you a powerpoint slide in order to help you understand.
AGAIN A BIG THANK YOU!


OPS....now I saw that ppt filetype is not permited...so i send it in a jpg image.
THANK YOU.
30216

May be you are looking for this. This is basically repeating the data. You will bloat your database!

Cheers
Raghu Prabhu

May be you are looking for this. This is basically repeating the data. You will bloat your database!

Cheers
Raghu Prabhu

THANK YOU.
I will check it and reply to you.