I'm not sure how to to do this:

I have a items list that keeps all my items with a unique number and name in addition I have a master price list that contains item num, name and price. I want to set up a rule so that as I enter the item number from a drop box that pulls from item (already have that set up fine) it will automatically populate the name field with the correct item name. How would I set that up?

Thanks

Welcome to the forum.

Is this the sort of thing you are looking for?

I was able to create a form that populates all the info that I am looking for, my question was more for work within the table.

When I go into table master price list and add a new item I would like to be able to enter the item number and have it populate the name automatically in the next cell then I enter the current price.

I was able to create a form that populates all the info that I am looking for, my question was more for work within the table.

When I go into table master price list and add a new item I would like to be able to enter the item number and have it populate the name automatically in the next cell then I enter the current price.

Sorry, tables don't work that way. Work in forms instead as they have events which you can harness to do things for you.