Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Display a related value in a subform

Questions related to customising nuBuilder Forte with JavaScript or PHP.
TitanCompMan
Posts: 4
Joined: Wed May 03, 2023 6:15 pm
Has thanked: 2 times

Display a related value in a subform

Unread post by TitanCompMan »

Currently, I have an inventory form with a sub-form of items. One of the fields is a funding ID. That shows the Funding ID number. I would like to display the funding type from he Funding table in the sub form instead of the funding id. Would I use the Display and SQL to display it?
When I click on the item in he subform I get my Item form and it displays the correct the fund_type with using a Lookup and that's the way I would like it to show in the Inventories' Items_subform (itm_sf).
Post Reply