This is Timesheet Entry Application. In Table1 combination of (user_id+date) makes primary key. There is 1 to many relationship between Table1 & Table2 with Enforce Referential Integrity option using above Primary key. I have one main form(using Table1) and related subform(using Table2), subform is related with main form using user_id & date. Problem is this whenever i enter user-id and date from main form and related activities in subform it works good for that day but next day for the same user_id when i enter new date it always display all the previous day activities also for that user.I want whenever i enter useer_id with a new date it should display a new blank record both in main and subform. Help me, how i can do that..
Try create an Autonumber field in Table1 (let's call it tbl1id), create an "longInt" field in table 2 (lets call it also tbl1id), set in Table1 the tblid field as the primary key and set the 1-M relationship to field tbl1id in table 2.