Newbie's task

mouzes

Hi guys. I hope that someone will help me.
I just started learning and my mate gave me 1 task to do as a training. He said that if I am struggling, I can use mibuso.com to get an answer. So the task is:
Create a table with
Item: Code (length 20)
Description. Text (length 50)

Next thing is - when you enter an item number the description cell need to show only first 10 letters.

List of the items needs to be 'drop-down list'.

I spend about 4 hours and only result i get is a massive headache.

Will you help me please?

Mouzes

Savatage

What have you tried?

Your new table and item number needs to have a lookup to the item table. Set a table relation.

On validate you can get the description from the item table. use copystr function to populate the new table description with the value and length you want. Modify your table.
https://msdn.microsoft.com/en-us/library/dd338944.aspx

To give you the full code wouldn't help you to learn anything. Take these guidelines and give it a try.