Help with pulling data from one form to another

Help with pulling data from one form to another

I have one form where I store the information of different store locations.

I have fields for the store number (not phone number it's a numerical id), store name, category name, and mall.

I have another form where I want users to input the sales data at the end of each business day. The first field is StoreNumber which is linked to the store number field on the first form. I want to make it so that when the user chooses the store number, the next field is automatically populated with the category name associated with that store.

I have found some other apps that do this but am having difficulty translating the scripts to my own app.

Any help would be great.
jacob