G
Guest
have a form that I created that is to add a new employee to our database.
We deal with insurance, so I want to be able to add a dependant to that
person's record. I have a form for new employee and a form for new dependent.
Once a person has filled in the new employee information, they should click
on a button that says add dependent. When the add dependent form opens, I
want the parent information to be automatically filled in.
For example, I have 2 tables: EmployeeInfo and DependentInfo. The
DependentInfo has a field called ParentSSN which is linked to the SSN
field in EmployeeInfo. When you add a new employee, you have to fill in SSN
in a txt box, and when you go to the add dependent form, I want the field
ParentSSN (its a txt box linked to the DpendentInfo table) to
be automatically filled in with the SSN from the new employee screen.
Can anyone help me with this?
Thank you!
We deal with insurance, so I want to be able to add a dependant to that
person's record. I have a form for new employee and a form for new dependent.
Once a person has filled in the new employee information, they should click
on a button that says add dependent. When the add dependent form opens, I
want the parent information to be automatically filled in.
For example, I have 2 tables: EmployeeInfo and DependentInfo. The
DependentInfo has a field called ParentSSN which is linked to the SSN
field in EmployeeInfo. When you add a new employee, you have to fill in SSN
in a txt box, and when you go to the add dependent form, I want the field
ParentSSN (its a txt box linked to the DpendentInfo table) to
be automatically filled in with the SSN from the new employee screen.
Can anyone help me with this?
Thank you!