I have 3 tables
ITEMS- PK = Item# - contains item detailsORDERS- PK = Order# - contains order summariesTRANSACTIONS- PK = Transaction# - Contains a breakdown of multiple transactions that make up an order
They all have an Item# column.
I have a one-to-many relationship from items.item# to orders.item#.
My question is: should the relationship to Transactions be from Items.Item# to Transactions.Item#, or from Orders.order# to transactions.order#?
Thanks