hi,
i have two from employee and designation. designation form two fields designation and salary. i have field salary in designation table .employee table have same field designation and salary.designation have combobox and salary have textbox. i want to access salary when i click on combobox selected field and display salary on textbox of salary in employee form.
Loading
AmitPosted Dec 27, 2014, 1:39 AM
Joginder BangerPosted Dec 26, 2014, 2:54 PM
I don't understand salary column have both form. simply create reference both table with the help of Primary Key and Foreign Key. Ok just forgot this come to your question, your question is when select any Designation on combox show the related salary in textbox.
create the comobox select index_changed and get the salary value behalf of designation.
Hemant SrivastavaPosted Dec 26, 2014, 10:36 AM
You question is not clear to me... where exactly you got stuck? From your description, I could make following design in my mind, does it reflect what you want?