[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


tables in database organization

Posted on 2011-10-29
Medium Priority
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
  • 2
LVL 21

Expert Comment

ID: 37051514
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

oleggold earned 2000 total points
ID: 37051517
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

ID: 37052688
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

ID: 37054540
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
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…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

872 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