Needed Professional way to link three tables using forms

lundi 4 mai 2015

I am self taught for Microsoft Access and have working with access databases for couple of years. I need to an expert way for the below scenario:

I have 2 forms, Form1 is used to enter staff personal and salary information while Form2 will be used to enter Bank information. I am using three tables to maintain this information:
1- Personal Info
2- Salary
3- Bank Details

All tables are joined in relationship by using a field StaffID which have to be entered manually as I can not use auto number. I have enabled cascade update and delete in relationships

The problem is if i use the Form1 to enter the personal & salary information, the StaffID which I enter in Form1 is automatically updated in salary table as Form1 is using both personal & Salary tables. But the StaffID is not updated in table Bank Details. This is crucial as this StaffID is a link between Personal and Bank table. Is there any way that when I enter StaffID in Form1 it will automatically append StaffID in Bank Detail table? Or can I use any query to append StaffID to Bank Details table.

Attached Files
File Type: accdb Sample Database.accdb (896.0 KB)
Needed Professional way to link three tables using forms

0 commentaires:

Enregistrer un commentaire

Labels