HELLO everyone first of all Hi i am new here my name is Faisal and i have just start learning MS ACCESS ,Okay my question is
i have 2 tables
Employee Data
Employee Ticket
i have all the information in employee data and i need some of that information in employee ticket too .
For example field One is Id number and 2nd field is Name 3rd field is department & and 4th field is designation IN EMPLOYEE DATA TABLE
now in EMPLOYEE TICKET i need Multiple joining like i put only ID NUMBER the name department and designation should be extracted from Employee data automatically is it possible ??
Il be highly thankful for quick response