Results 1 to 11 of 11

Thread: newbie question

  1. #1
    Join Date
    Mar 2004
    Posts
    10

    Smile Unanswered: newbie question

    I'm trying to create a table so that when you enter data, its a pull down menu so you just select when you want instead of typing it. For example, the Fields are Movie, Actor and Movie Genre and for Movie Genre, you can then select Science Fiction, Action, Comedy, Romance, Horror, etc... which i typed in another table.
    Last edited by Agent_J; 03-28-04 at 01:04.

  2. #2
    Join Date
    Jan 2004
    Posts
    31
    Set up the table with the fields that you want in it and create a form that is linked to the table you want to enter data into. In the form you can create a combo box that does exactly what you are looking for.

  3. #3
    Join Date
    Mar 2004
    Posts
    10
    i tried creating the form, but now it says i need to edit the relationships? do you know how to configure that?

  4. #4
    Join Date
    Nov 2003
    Posts
    1,487
    Attach your database...

  5. #5
    Join Date
    Mar 2004
    Posts
    10
    thanks cyber, here it is
    Attached Files Attached Files

  6. #6
    Join Date
    Jan 2004
    Posts
    31
    The office has Access 97 and I am unable to open the db. Is there an option in your version of access to convert the db to work in '97?

  7. #7
    Join Date
    Mar 2004
    Posts
    10
    ahh finally figured it out, here it is snake
    Attached Files Attached Files

  8. #8
    Join Date
    Jan 2004
    Posts
    31
    what are you trying to accomplish with all of this data? Are each of the tables sources for the combo boxes? What information do you want in the final table?

  9. #9
    Join Date
    Mar 2004
    Posts
    10
    I'm trying to make a database of all the computer video cards. Yes, I am trying to make the tables sources for the combo boxes. In the final table, i just want to be able to have a combo/drop down menu under Manufacturer, DirectX, buswidth, pipes and interface so i can just select them instead of typing them which would reduce errors

  10. #10
    Join Date
    Nov 2003
    Posts
    1,487
    Here it is again with a bit of a twist.......

    Attached Files Attached Files

  11. #11
    Join Date
    Mar 2004
    Posts
    10
    its awesome cyber, thanks

Posting Permissions

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