is there any way that i can add duplicates in a record?
by the way,my program contains a frmAdd where user adds in a task and its description, and this gets stored in the database. Looks like when i add a task with the same name but different descriptions, my program seems to read in both tasks as the same one, and completely ignores the other one!

Could you give more details?
What is the action that results in “completely ignores the other one”?
What is the manifestation of “completely ignores the other one”?
What DB system is this?

i am using MSAccess 2003 with VB6.
in my frmAdd(VB),i have txtTask,txtDocuments,DTPicker(to show due date),txtDays,txtAttach,txtNotes and command buttons,cmdSubmit,cmdBack. when i add new tasks, my program writes to the db which stores these added tasks and displays it in a report also in db.displaying in the report is fine!
meanwhile,say i add a task 'Appointment meeting' with all the necessary details in the appropriate txtboxes, i click submit, my task is stored in the db. then i add another task with the same name, but choose a different date from the DTPicker. now, my program should read that as a different task from the first one..but looks like, it completely ignores the first one added, and reads in the 2nd one as same as the 1st one.

in my db, i have a table 'AddRecord' where these added tasks are stored, it has the fields as from the frm, Task, Documents, DDate, Days, Notes, Attachment...i have id as an autofield number, should i assign this as my PK?

Commonly the auto generated identity field (Autonumber field in Access) is used as the primary key for a table.

I am a little confused here: You state that your "program" should read records that have the same name as separate tasks, and that makes sense. But what doesn't make sense is that this is your program, and your code... it won't do anything on its own without you having written the instructions. SO it is not your program that is ignoring the first record, so to speak, but instead it is your instructions that retrieve or display the records that are incorrect.

So you need to look at whatever part of your code that retrieves and/or displays the records to see why it is only retrieving the most recent record of with a particular name. This could be in your sql select statement, or it could be in some code you have written that displays the records.



Woody Z http://www.learntoprogramnow.com