Hi Everyone,
I am having a problem while using lookup column.
I am trying to refer some other table values by using lookup column, its working but its not displaying the complete data. For example, I want to connect Table1.Column1 to Table2.Column1 whose data type - text. It has values like M0001, M0002. When I look in datasheet view of Table1.Column1, its displyaing a drop-down list of 0001, 0002.
I want the complete data. How can I do that?? Can anyone Please help me.
Thanks in advance
I am having a problem while using lookup column.
I am trying to refer some other table values by using lookup column, its working but its not displaying the complete data. For example, I want to connect Table1.Column1 to Table2.Column1 whose data type - text. It has values like M0001, M0002. When I look in datasheet view of Table1.Column1, its displyaing a drop-down list of 0001, 0002.
I want the complete data. How can I do that?? Can anyone Please help me.
Thanks in advance