Susan Harkins
harkins at iglou.com
Sun Aug 3 09:00:01 CDT 2003
Julie, set the page's Recordset Type property to Dynaset (Inconsistent Update). Susan H. > Susan, > > > Here is the sql statement. Hope this helps. Why so many restrictions on > DAP's? > > SELECT CardInventory.item_no, CardInventory.item_desc_1, > CardInventory.prod_cat, CardInventory.loc, CardInventory.item_weight, > CardInventory.user_def_fld_1, CardInventory.user_def_fld_2, > dbo_IMLSMST_SQL.ser_lot_no, CardInventory.user_def_fld_3 > FROM dbo_IMLSMST_SQL INNER JOIN CardInventory ON dbo_IMLSMST_SQL.item_no = > CardInventory.item_no > WHERE (((CardInventory.loc)="c")); > > > > Julie Reardon-Taylor > PRO-SOFT OF NY, INC. > www.pro-soft.net > > _________________________________________________________________ > MSN 8 with e-mail virus protection service: 2 months FREE* > http://join.msn.com/?page=features/virus > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >