List1 and List2 information are show in the Picture attached. Both of them are sharepoint list. Please see the pic first.
List1 acts as a back-end database. List2 acts as an input information base.
I want to use edit form type for list2. And the Choices for the first two column base on LIST1 corresponding column.
When edit form list2 and if i choose "pencil" in Description column. And the the Material Code and Quantity column will show the value corresponding to list1 "pencil "row automatically. And i can submit this information to list2.
How to fulfill this function?
Thank You!
Dennis
