I have two custom lists. List A has an custom form built in SPD (SharePoint Designer). List B is only used for display. Both lists have a common column called devcode. It is unique in List A; There is a one-to-many relationship in List B.
In List A, there are three fields - HR, Admin, Mgmt
In List B, there are fields where money is associated with fields: for example HR$ - 45000; Admin$ - $23000
I need the field Mgmt in List A, to be greyed out if there is no Mgmt$.
Any ideas appreciated.