Good morning everybody, I'm a newbie, struggling with this:
I think the solution is a few "one to one relations" (each with the set of data that the single employees has to manage.
- I have a huge set of data (fields never used anywhere else!only one shot!)
- these data have to be populated by different employees so, in order to:
- reduce a sinle huge table
- authorize each employee to populate a different mask
my problem is how to create in access 2007 a one to one relation
actually I do create it, but it does not work?
how can I populate data?
If I check integrity I can' add a field in nor of the 2 tables!
each one says that cannnot add a filed because the other one hasn't any record related to (ad a dog that bites itself tail!)
whereas with no check for integrity I can add a record in the secondary table that I can open inside the primary, BUT I can't see it anymore when I open the table again. Nor I can't see any record added..
I can't see it inside the secondary table, wherease it's actually added to the secondary table, if I open this table separately the added record exists!
how can I populate and manage a one to one relation???
or there is some other solution (without having to write a loooong code... :-O)
THANKS!!!!
Bianca