AccessNovice123
Registered User.
- Local time
- Today, 02:38
- Joined
- Aug 16, 2017
- Messages
- 13
Hello,
I have a customers database and within in there, I have tabbed subforms within tabbe subforms to view specific and organized data. For example, users can click on the Employment tab (all tabs within this form correspond to my emp_tbl) which will take them to subform with tabs (Skills, Range, Trade School, State, Certifications).
I need to click on the "Add Record" button while I am in a customer record and have it create a new record in my emp_tbl for the existing customer. My cust_tbl has the pk = CUST_ID and is the fk in emp_tbl with the pk = EMP_ID. So, for the existing customer, I need to add a record to the emp_tbl associated with the CUST_ID. I would like to be able to do this by going through each tab but otherwise I could create a modal to enter the new data.
My customers and employment table have an inner join on CUST_ID...so one customer can have many EMP_ID records.
I am working in Access 2016.
Any help is greatly appreciated. Thank you in advance. I am a novice at best.
I have a customers database and within in there, I have tabbed subforms within tabbe subforms to view specific and organized data. For example, users can click on the Employment tab (all tabs within this form correspond to my emp_tbl) which will take them to subform with tabs (Skills, Range, Trade School, State, Certifications).
I need to click on the "Add Record" button while I am in a customer record and have it create a new record in my emp_tbl for the existing customer. My cust_tbl has the pk = CUST_ID and is the fk in emp_tbl with the pk = EMP_ID. So, for the existing customer, I need to add a record to the emp_tbl associated with the CUST_ID. I would like to be able to do this by going through each tab but otherwise I could create a modal to enter the new data.
My customers and employment table have an inner join on CUST_ID...so one customer can have many EMP_ID records.
I am working in Access 2016.
Any help is greatly appreciated. Thank you in advance. I am a novice at best.