I have 2 forms. 1 holds a constant list of items, the second is a fixed schedule of events that includes the item number. In a view for the schedule, I need to pull in one field associated with the item number on form one, but the location on form 2 (schedule) will change throughout the dates on the schedule.
How can I can I set schedule view (form 2) to use a variable on the changing field so that it relates back to a field on form 1 (item list). Both forms contain the same item number.
I contacted support but they were unable to provide a solution.