hi,
in my branchtable, i have :
- branchCode (pk)
- branchName
in my staff_table, i have : (these are the fields that will be on my main form)
- staff id
- name
- contact no
in my staff_account_table , i have : (these are the fields in my subform)
- accountno
- account type
- branchcode (link to branchtable - fk)
- salary
- staffid (link to staff_table- fk)
i have another form that displays all the information on this staff when they select from the combo box. the form include fields of :
- staffid
- name
- contactno
- branchName (from branchtable)
- accountno
- account type
- salary
how can i display the all this information in my form. how can i link all these 3 tables to display the info?? how can i retrieve the branch code of the staff and display it as branch name in this form??
this is what i have done: under the record source of my form, i place this codings
SELECT staff_Table.staffid, staff_Table.name, staff_Table.[contact no], staff_account_Table.[account no], staff_account_Table.[account type] , staff_account_Table.[salary] FROM staff_Table INNER JOIN staff_Account_Table ON staff_Table.staffid = staff_Account_Table.staffid WHERE (((staff_Table.staffid)=Forms!frmSearch!cboSelectG roup));
how can i display the branch name???
pls advice
nono
|