Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jul 2009
    Thanked 0 Times in 0 Posts

    Paradox.... HELP!

    I'm a student (high school) and beginner scripter and currently working in an office for the summer updating databases and other boring junk like excel. Until now that is for I've been given another job: to update/repair an old but functional Paradox/ObjectPal database and I'm currently neck deep in literature on the stuff but I have a question on something I cannot seem to find anywhere in the books.
    Can you place drop down menus in a table and if so, how?

    I'm currently as a first project recreating/simplifying a pre-existing table that has 4 currently Alpha inputs.
    I'll just call them X, Y, Z, and N.
    X is the name
    Y is the size
    Z is special notes
    N is the Job Number that X was used in

    It is sorted with N being the primary key and X being the secondary as per N there is over 20 X's.

    What would you suggest I do?

    Thanks for your time.

  • #2
    New to the CF scene
    Join Date
    Jun 2009
    Bedfordshire, UK
    Thanked 0 Times in 0 Posts
    What do you want to see in the drop down table?

    What version of Paradox are you using? What reference books do you have?

    You can use lookup tables which drop down over the current display but you need to have the drop down data in a separate table and set up the tables and link them. Tools>Utilities>Restructure is where you specofy the behaviour of the tables.

    Do you understand the principles of relational databases and the need to keep data in normalised tables then relate them in the data model?

    Best wishes.


    Posting Permissions

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