Hi, I am having major brain fade. This is a one to many relationship. I have an order that contains many items. Each item is a one off unique item.
I have a table that has order data,
item (show me all items in this order)
I have a table that has Items
orderid (which orderid this item is on)
Can anyone help?