I have the following problem :
One table : tblProspects/Clients with One to many relationship
Two Queries : QueryProspects and QueryClients both linked to
tblprospects/clients
Two Forms : FrmProspects with queryprospects as record source and FrmClients
with queryclients as recordsource.
Whereas I can add and modify records thru FrmProspects to
tblprospects/Clients, I can not do the same thru FrmClients whose
queryClients is not updatable which I don't understand.
The principle behind this is to have Prospects records turned into Clients
records within tblprospects/clients thru a criteria (Prospects to Client)
changed as soon as another form is used and validated.
I would greatly appreciate some help on this one.
Thanks in advance

Frankie