meezadahsra
New member
- Local time
- Yesterday, 16:02
- Joined
- Jan 23, 2013
- Messages
- 8
hello experts
i have created 6 tables and individual forms for each of them to fill those tables.
also i have reports which are bounded to 4 of these tables/forms.
my problem is this :
i have successfully filled the tables using these forms. but whenever i open it the next day or so, the data in some of the tables gets mixed up.
For eg:
>my EMPLOYEE DETAILS has the emp no as primary key, and is linked as lookup field in other tables. (so tht user may select emp no and then enter details in FORMS)
>my EMPLOYEE ADRESS table's (report not linked) data gets interchanged according to emp no.
instead of being 1,2,3,4,5,6 (as i entered), its 2,3,4,5,6,6.
>sometimes my other tables also have these problems.
is there a reason why this is happening ????
what could be the problem?
PLZ HELP !!!!
i have created 6 tables and individual forms for each of them to fill those tables.
also i have reports which are bounded to 4 of these tables/forms.
my problem is this :
i have successfully filled the tables using these forms. but whenever i open it the next day or so, the data in some of the tables gets mixed up.
For eg:
>my EMPLOYEE DETAILS has the emp no as primary key, and is linked as lookup field in other tables. (so tht user may select emp no and then enter details in FORMS)
>my EMPLOYEE ADRESS table's (report not linked) data gets interchanged according to emp no.
instead of being 1,2,3,4,5,6 (as i entered), its 2,3,4,5,6,6.
>sometimes my other tables also have these problems.
is there a reason why this is happening ????
what could be the problem?
PLZ HELP !!!!