Hello,

Your problem is example of many to many relationship designing.

For maintaining it you need to create one more table which will contain only OrderID and TransactionID and it will work like a bridge table between these two tables.

Please check below links for referenace -

http://discoversql.blogspot.in/2012/04/database-modelling-many-to-many.html

http://www.techrepublic.com/article/get-it-done-solve-a-many-to-many-relationship-problem-in-microsoft-access/#.

Regards,

Gourav Saxena

Data Warehouse Consultant

GouravSaxena1987@gmail.com