Intresting DBGrid/Database?SQL ques??? - need urgent help!!!!

[raj]

Hi everybody;
Another DBgrid grid kinda ques for u all...thanx for ur time guyz!!!so here's is it:
I have a DBgrid on the form..so what i'm doing is adding records in that DBgrid which is bound to access database...
Everything's workin fine. The only problem is when i load the form again it shows up all the records that were added last time and before(the one's that are already in the database).
So what i want is; its should show the DBGrid
totally blank to add new records without showing the old ones in database.........
if anyone has any ideas how to do this, please let me know.....
anyway by making rows invisble, or by sQl.....or any
other way i can do this :rolleyes:
thanx a lot
Cheers ;)
Raj :)

It's all about how you set up the data source that the grid is bound to. I would probably add a column to the database called "isNew" or something and use it to mark whether the row should be shown. Set the recordSource property of your data control to "SELECT * FROM myTable WHERE isNew = FALSE" and then execute the .refresh method.

Hope That Helps

-John