SQL server Northwind UnitPrice demystifying.

  • in 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 Database

    Option Explicit

    Private 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 If

    End Sub

    Now 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? Can anyone demystify this?

  • Um, 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...?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply