Moving(adding) records from one list to another??

[qajussi]

Hi,
I need a kickstart in how to go about doing this.
Basically, I have three lists on the SharePoint site(2003), MasterList, AList and BList.

Each of those lists have same column names and type. They are same lists.
Let's say these are the column headings:

MasterList(ProjectNum,Name,StartDate,ProjectStatus)
AList(ProjectNum,Name,StartDate,ProjectStatus)
BList(ProjectNum,Name,StartDate,ProjectStatus)

ProjectStatus has choices(Active, Accepted, Rejected)

What I want to do is I want to move(or add) records from AList and BList to MasterList when record's status changes to 'Accepted'.

I guess I need to do some Web part programming.
I am not sure where to look at in order to do this.
Is there a site or something that I can go to learn how to tackle this?
Thanks much.

 

[Vince999]

Couldn't you use one list with a series of views and filter by project status

 

[Dodswm]

Yeah - i would do it all on one list

 

[qajussi]

I thought about that too.

Do you know how to create auto-increment columns?
There is one id column but I need additional column to filter out records??

Thanks much.