P
prairiewind via AccessMonster.com
I have a database with three linked tables (parent table, a child and a
"grandchild" table). There are 8 field reps in the company I work for. Each
of the parent tables cooresponds with the data pertaining to each rep. What
I'm wanting to do it to somehow separate the data so I can send each rep just
their table and corresponding children tables, they update the data and send
it back to me. Is there a way to do this? I have found a way to do it with
all the data in one table, but the forms to enter data end up being cluttered,
hard to navigate and confusing.
"grandchild" table). There are 8 field reps in the company I work for. Each
of the parent tables cooresponds with the data pertaining to each rep. What
I'm wanting to do it to somehow separate the data so I can send each rep just
their table and corresponding children tables, they update the data and send
it back to me. Is there a way to do this? I have found a way to do it with
all the data in one table, but the forms to enter data end up being cluttered,
hard to navigate and confusing.