tables in database organization

Posted on 2011-10-29
Last Modified: 2012-05-12
i have created a database in mysql that have maybe more than 30 tables and one of these table has more than 50 fields maybe 60 fields in total,really i find it very hard to create a form for this table it will be a big form any idea please
these tables were created in mmsql server before ,and i recreate them but i did not change the system means i left it as it was
Question by:asaidi
    LVL 21

    Expert Comment

    create views with lesser number of fields , actually just select the forms Your users will  need , if possible ,use dynamic design when You can add a field or a dynamic field as a list value (lov) for the form
    LVL 21

    Accepted Solution

    good GUI design requires minimum time Your user will spend on the form unless it's a list report ,and even then,use minimalistic design to get what user wants and dynamic rendering for adhoc reports

    Author Comment

    thank you for your answer
    but what about if the user wants to create a data
    my problem is that the table is very big makes the form very big makes the user not happy
    LVL 24

    Expert Comment

    what are you using the create the form?  you should be able to customize it so that only the required fields have to be filled up.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now