Dynamic Lookup Field Filtered Based on Bi-Directional Relationship
I'm stuck on an issue and could use a little help.
I have an Accounts form and a Contacts form. The Contacts have a bi-directional relationship with Accounts using a dynamic lookup on Account Name. The relationship is 1 Account to Many Contacts.
I have a third form where I select the Account Name first, then a Billing Contact and a third field for Technical Contact. The two contact fields are dynamic lookups for the Contacts form on Full Name. Everything works well now but I'd like Billing Contact and Technical Contact to be filtered by Account Name instead of showing all contacts.
I've attempted to set filters for input.Account_Name but get an error saying I'm trying to match a string to a BIGINT which I think it happening because Account_Name is a dynamic lookup and must be using an ID instead of the text. This seems like it should be easier but I must be missing something.