locked
Lookup list base on Two deferent tables RRS feed

  • Question

  • Hi

    Here is a scenario, I have following table

    Product
        ID
        Name
        Price
        Qty
    Vendor
        ID
        Name
        Address

    Customer
        ID
        Name
        Address

    Transaction
        ID
        Type(Purchase/Sale)
        Date
        VendorOrCustomer

    TransactionDetail
        TransactionID
        ProductID
        ProductPrice
        Qty

    I need to accomplish two things;
    1.    When I select Type “Purchase”, then VendorOrCustomer show me choice list from Vendor Table and if I select Type “Sale”, then VendorOrCustomer show me choice list from Customer Table.
    2.    In TransactionDetail when I choose Product then product price also stored in TransactionDetail and I don’t input Qty greater then product qty from product table.

    Thank you,

    Saturday, June 27, 2015 3:29 PM

Answers