⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠
Posted 13 September 2019 - 16:57 PM
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,
orderid
totalcost
date
item (show me all items in this order)
I have a table that has Items
itemid
itemname
orderid (which orderid this item is on)
Can anyone help?
Posted 14 September 2019 - 00:09 AM
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,
orderid
totalcost
date
item (show me all items in this order)
I have a table that has Items
itemid
itemname
orderid (which orderid this item is on)
Can anyone help?
Hi GaryW!
What are you trying to do?
Posted 25 September 2019 - 21:32 PM
Hi GaryW!
What are you trying to do?
Hi Larasmith.
I am trying to display a results page that shows an orderId with all if the items that have that same orderID. So if i look at orderid 1 i can see all the items that belong to order id 1.
Posted 02 October 2019 - 17:41 PM
Hi GaryW.
If I understand you correctly, you may use setActionButton on your orders page to send orderid to items page. Then use items table and where to display only items from that order.
