This topic is locked

Read Only Lookup Field

3/6/2019 6:06:43 PM
ASPRunner.NET General questions
I
i.NoLim author

Hello,
I have 4 fields: FiscalYear, Department, Account and Remainder. I would like for Remainder to be a read only value that auto populates depending on the other 3 fields. I already tried "This dropdown is dependent on...," in fact Department is dependent on FiscalYear and Account is dependent on both FiscalYear and Department, and it works... sometimes. Sometimes it acts a bit funky where after selecting the other 3 values the correct Remaining value flashes really quickly but its not selected and I'm not able to do so, only "Please select" is available. Additionaly, I was not able to figure out how to make it read only (HTML?).
I'm guessing it will be a JavaScript OnLoad Event that checks when Account changes, as that's the last field being selected, and then does a SQL query.
Any help would be appreciated.
Thank you!