⚠ 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. ⚠

  •     

profile picture

Show related data



GaryW

GaryW
  • profile picture
  • Member

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?

 


larasmith

larasmith
  • profile picture
  • Member

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?


GaryW

GaryW
  • profile picture
  • Member

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.


Soreno

Soreno
  • profile picture
  • Member

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.