This topic is locked

limit records to 5 while detail/child table

9/25/2022 11:41:47 AM
PHPRunner General questions
P
ppradhan@live.com author

Hi,
How to limit details record to 5 but no limit while opened as main/master table?
Eg: Master Table: Order
Detail Table : order_detail

These tables are in relationship (Master-Detail).

When opening Master Table: Order, the order_detail table should limit record to 5.

But when I open order_detail table alone/ or single table the limit should not be applied.

Please advise how to achieve this?

with regards