Data reduse un Table

So are you saying that you have transactions in a table that you need to apply to stores in a table?

There are many ways to do this. Do you know if you want to create a Console, Windows Forms, WPF, Silverlight or some other type of program?

One common way to do it is to use a join to join the stores with the transactions. Are you familir with joins? They are like database relationships in Access.