Page 1 of 1

Display a related value in a subform

Posted: Mon Jan 29, 2024 6:23 pm
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).