InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 12:02:42 GMT20http://www.sqlservercentral.com/Forums/Topic880856-131-1.aspxUm, what forms are you running on your SQL 2008 database? Because unlike Access, SQL Server does not have a Forms system of its own, you have to use forms from some other facility...?Fri, 12 Mar 2010 05:53:38 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic880856-131-1.aspxin the MS Access version of Northwind to get the Unit price on selected index change of product. they intoduce a GetListPrice in the code behind of Order Subform. Like:Option Compare DatabaseOption ExplicitPrivate Sub Product_ID_AfterUpdate() 'Initialize price and discount for each product change If Not IsNull(Me![Product ID]) Then Me![Quantity] = 0 Me.Quantity.Locked = False Me![Unit Price] = GetListPrice(Me![Product ID]) Me![Discount] = 0 Me![Status ID] = None_OrderItemStatus 'Empty Product records mean user wants to delete line item Else eh.TryToRunCommand acCmdDeleteRecord End IfEnd SubNow on the SQL server 2008 version there a similar database however everything seems to work somehow like a well oiled engine without the code behind. ummm...How is this achieved automatically calling the ListPrice from the Product table based on OrderItem selected product. Am I missing s:doze:mething? [b]Can anyone demystify this?[/b]Thu, 11 Mar 2010 03:37:03 GMTcyrus777