I have two tables tableManager and tableEmployees
with one to many relationship...
Is there a way to add all the 10 employees, previously under Manager A, under a Manager B also
This reads like it's a many to many relationship, in which case you're probably missing a table. Seems to me like you'd need tblMgrs, tblEmployee and tblMgrEmpl, the 3rd being a junction table. I might have misunderstood the post, though.
and another listbox listEmployees with row source value list.
I'm not getting how this is cascading at all. One is a full table list and the other is a value list? I've never heard of "cascading" when a value list is involved in a 'child' control.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.