I created a seperate form named “Admin Customer” where i want to be adding the names of customers. i also created a view for this form.I want to tie this particular field to another fields called “Customer id” and “Contact Person”.
I mean, i want whenever i pick a customer, it should automatically bring out the customer id and the contact person.
This is what i have done so far:{1}I created a field in the main form called “customer”,made it an editable dialog list and chose “use fomular for choices”, with the following code;@Unique(@DbColumn( “” : “NoCache” ; “” : “” ; “ACV” ; 1 )).
(2)i created another field called “customerid” and “contact person”, i made them computed textfields. then in their field value, i put this code "@Unique(@DbColumn( “” : “NoCache” ; “” : “” ; “ACV” ; 1 ));
@If (Name=“ACCESS BANK”;"NGNABN “;Name=“UBA”;“NGNUBA “;Name=“FSDH”;“NGNFSDH”;Name=“GATEWAY BANK”;“NGNGTW”;Name=“IBTC”;“NGNIBTC”;Name=“IMB”;“NGNIMB”;Name=“PRUDENT BANK”;“NGNPRUDENT”;Name=“BOND Bank”;“NGNBOND”;Name=“NEXIM Bank”;“NGNNEXIM”;Name=“TMB”;“NGNTMB”;Name=“SAFETRUST”;“SAFETRUST”;Name=“FSB”;“FSB”;Name=“Citizens Bank”;“Citizens Bank”;Name=“SGBN”;“SGBN”;””)”
When i did this without having a separate form for the customer, it worked, but i dont know why its not working with this.
Does anyone have an idea of what i should do and i didnt do/do right?
Pls, help
Debo