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

    Unanswered: Help please. (school project)

    Hello people i am brand spanking new to this forum.

    I am making a database for a pizzeria.

    I was wondering how you can make a dropdown box with specific words (hawwaiin, meatlovers, etc.), so that information would then be saved for a pizzaID under the fieldname 'Flavour'.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    have a table called, say PizzaTypes or PizzaFlavours
    that should have something that is unique to that row and a description. the unique bit could be an autonumber column, it could be a code. of the two an autonumber column is the more common

    eg
    table PizzaTypes
    ID Integer(Autonumber) ' index of the PizzaType
    Description Text(50) ' describes this type of Pizza

    then on your form that handles the selection (im guessing its going to be an order form) use the combo box wizard. select the data source for the control as the table PizzaTypes or whatever you called it
    in
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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