T
Tony
I have 3 tables that I am trying to trap key values on to perform an insert:
Table A is Employees (Key ID and Key RecNbr)
All employees in the company
No Relationship to the other two tables
Table B is Referrals (Key RefID)
Complaints re: Employees
1 To Many with Table C
Table C is Ref_Empl_Info (Key RefID,Key ID,Key RecNbr:Indexed/No Nulls)
The Employee attached to the Referral
Form B(table B) has a subform, Form C (table C) that links the Referral
Information and any already existing existing employee information by keys.
When Form B is open the subform for Form C carries the key from B to C
as it should and the subform displays any keys Ive manually added to the
Table C.
My problem is adding new Employees to the subform (combining the Key
values from form B and form A to perform a valid insert into Table C.
I would like to give the user the ablility to open the Employee's Form
and select the employee to be added to Table C. However, the values of
the keys go out of scope when using Public variables or Class methods
once the Employee form opens(modal to prevent user from closing form B).
Can anyone tell me how you can
1. With form B open, Open Form A, trap table A Keys, combine form B key
with form A keys for a valid insert into table C?
The scoping on this is killing me. It seems that I read somewher e that
you cant do this in access without creating temp table to capture values
but I find that hard to believe.
Any help would be greatly appreciated.
Tony
Table A is Employees (Key ID and Key RecNbr)
All employees in the company
No Relationship to the other two tables
Table B is Referrals (Key RefID)
Complaints re: Employees
1 To Many with Table C
Table C is Ref_Empl_Info (Key RefID,Key ID,Key RecNbr:Indexed/No Nulls)
The Employee attached to the Referral
Form B(table B) has a subform, Form C (table C) that links the Referral
Information and any already existing existing employee information by keys.
When Form B is open the subform for Form C carries the key from B to C
as it should and the subform displays any keys Ive manually added to the
Table C.
My problem is adding new Employees to the subform (combining the Key
values from form B and form A to perform a valid insert into Table C.
I would like to give the user the ablility to open the Employee's Form
and select the employee to be added to Table C. However, the values of
the keys go out of scope when using Public variables or Class methods
once the Employee form opens(modal to prevent user from closing form B).
Can anyone tell me how you can
1. With form B open, Open Form A, trap table A Keys, combine form B key
with form A keys for a valid insert into table C?
The scoping on this is killing me. It seems that I read somewher e that
you cant do this in access without creating temp table to capture values
but I find that hard to believe.
Any help would be greatly appreciated.
Tony