Jump to content


Show related data

group relationship

  • Please log in to reply
3 replies to this topic

#1 GaryW

GaryW

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 13 September 2019 - 04: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?

 



#2 larasmith

larasmith

    Advanced Member

  • Members
  • PipPipPip
  • 199 posts
  • LocationPhilippines

Posted 14 September 2019 - 12: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?



#3 GaryW

GaryW

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 25 September 2019 - 09: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.



#4 Soreno

Soreno

    Member

  • Members
  • PipPip
  • 14 posts

Posted 02 October 2019 - 05: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.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users