I have two local views:

The first one (lvWorkOrder_Weigh_b):

SELECT Workorder_weigh.key, Workorder_weigh.id,;
Workorder_weigh.teditstamp, Workorder_weigh.ceditby,;
Workorder_weigh.taddstamp, Workorder_weigh.caddby,;
Workorder_weigh.nroll, Workorder_weigh.nweight_roll,;
Workorder_weigh.nskid, Workorder_weigh.nweight_skid,;
Workorder_weigh.cseals, Workorder_weigh.cdiameter,;
Workorder_weigh.cwidth, Workorder_weigh.nslip,;
Workorder_weigh.ngmmeter, Workorder_weigh.nimpact,;
Workorder_weigh.ndyne, Workorder_weigh.nopacity, Workorder_weigh.cqcby,;
Workorder_weigh.cworkorderid, Workorder_weigh.cstatus,;
Workorder_weigh.dstatus_date, Team.ccode AS cteamcode,;
Workorder_weigh.cteamid, Workorder_weigh.coperatorid;
FROM imaflex!workorder_weigh LEFT OUTER JOIN imaflex!team ;
ON Workorder_weigh.cteamid = Team.id;
WHERE Workorder_weigh.cworkorderid = ?saleorder_items.cworkorderno;
AND EVALUATE(?pcFilter) = .T.;
ORDER BY Workorder_weigh.taddstamp DESC

The second one (lvWorkOrder_Weigh) :

SELECT Lvworkorder_weigh_b.*, Employee.ccode AS cemployeecode,;
Employee.cfname, Employee.clname;
FROM imaflex!lvworkorder_weigh_b LEFT OUTER JOIN imaflex!employee ;
ON Lvworkorder_weigh_b.coperatorid = Employee.id;
ORDER BY Lvworkorder_weigh_b.taddstamp DESC

When adding a record to lvWorkOrder_Weigh and sending a TABLEUPDATE() to the WorkOrder_Weigh table, the record is not saved. If I add a second record the first addition is saved into the table...
If I add a third record the second addition know gets saves, and so on....

How do I keep these views and send a proper update the table properly?

I need two views because I need to display the employee name as well as the team for every record of workorder_weigh = > (lvWorkOrder_Weigh)