AnsweredAssumed Answered

Can a portal display information from 2 related tables

Question asked by sidetrack_ca on Nov 22, 2017
Latest reply on Nov 22, 2017 by philmodjunk

I have a layout that shows records from a table called ::staff.  There are related tables called ::CommissionHeader and ::CommissionDetail.  I am entering information to both of those related tables.  When the person saves that information I want the information to be moved to a portal that is on the same layout.  Example:

User enters:

Sale Date

Product Name

Product Cost

Sell Price

 

when they press a button the information is shows up in a portal on the same layout.  This way when a person is entering their sales for the month the portal shows all sales for the current month in a scrollable portal window

 

Thanks for your advice and help


Rob

Outcomes