Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013
    Posts
    1

    Unanswered: Need Help doing 2 small things.

    Hi I got assignment due, I've doe everything but I cant see to do this:

    1. Alter the database so that the serial number can be recorded at the time of sale.
    .
    2. In order to improve the integrity of the data as it enters the database, you should implement the following business rule:

    When a serial number is recorded in a sale, the quantity purchased must be one. In other words — the serial number must be blank or the quantity must be 1

    This might seem easy but Im so stuck, been stuck for 2 hours already . The Data type of SerialNoRequired is Yes/No which cannot be changed in the assignment. Here is the ERD for this assignment:

    http://farm3.staticflickr.com/2842/9...d39afa05_c.jpg
    ERD by wuchildnz, on Flickr

    just so you know what needs the serial number its in the commodity table

    TypeID TypeDescription SerialNoRequired
    D Dietary Suppliment No
    E Gym Equipment Yes
    P Product No
    S Service No
    W Wearable Item No
    Last edited by wuwi9989; 09-03-13 at 03:19.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Personally I'd use the before update event of the form:

    Before update
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •