Hi Guys,

Is it possible to insert into two tables from the one screenform.
I have setup new tables and created a screenform to insert into them, but only one of the tables appears active on the form once compiled.

Is there a way around this.

Barry.

one screen defenitely can work with many tables. did u run dbschema after setup your table? then recompile your form4gl

Hi Tonny,

Ran dbschema, still the same after recompiling the screenform.

Below is form.. any ideas???

************************************************** ***
database audit@hertclust_soc
screen size 24 by 80
{

***** METEOR LIFETEST SCREENFORM ******

Source: [f00 ] Code_1 : [f009 ]
Exp_No: [f001 ] Code_2 : [f010 ]
MID : [f002 ] Code_3 : [f011 ]
Meteor_Lot :[f005 ] Code_4 : [f012 ]
Date_Tested:[f006 ] Code_5 : [f013 ]
Tester : [f007 ] Code_6 : [f014 ]
Op_Id : [f008] Pag_p : [f015]
product_id: [f016 ]
Comments : [f017 ]


}
screen
{

]
}
end
tables
stor
metper

attributes
f00 = metper.source, reverse, upshift;
f001 = metper.exprmt, reverse, upshift;
f002 = metper.mid,reverse, upshift;
f005 = metper.meteor_lot, reverse, upshift;
f006 = metper.date_test,format="mm/dd/yyyy" ,reverse,upshift,default =
today;
f007 = metper.tester,reverse,upshift,comments = "Enter a Line ID";
f017 = metper.comments, reverse, upshift;
f008 = metper.oper_id, reverse, upshift;
f009 = stor.code_1,reverse, upshift;
f010 = stor.code_2,reverse,upshift;
f011 = stor.code_3,reverse,upshift;
f012 = stor.code_4,reverse, upshift;
f013 = stor.code_5, reverse, upshift;
f014 = stor.code_6, reverse,upshift;
f015 = stor.pag_p,reverse,upshift;
f016 = stor.mid,reverse,upshift;
end
************************************************** ***