Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

0

0
Álvaro Damas
Ligar 14/12/21, 16:01

The way to approach this challenge is to change the data structure. Your example is violating the "First normal form" of database normalization. (Google "First normal form" and there are too many examples to understand the concept). You must change, from having multiple fields of the same subject in a record, to having a column with the subject field in a list. For example, in a person's table, you should not put multiple fields for home address, business address, alternate address, etc. What you should do is create an Address table related N:1 to the Person table. In this Addresses table there is a field with the Address and another to enter the Address type (Home, Work, Alternative, etc).

After the changes, when viewing a Person form, a list of records with the various addresses in a column will appear, instead of several fields with Addresses in the form.

2022-01-11
You need to change the structure of the database as advised above. If you don't change the structure you will have big scalability problems.


  • Flag

But the 179 text boxes that I have, they are not text boxes for the same thing, they have different purposes and different values for each one of them.

Micael Machado (Oceanxbox)
ativo 16/12/21, 15:05

Still waiting for a reply...

Micael Machado (Oceanxbox)
ativo 11/01/22, 17:07

Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

43 follower(s)

Stats

Asked: 13/12/21, 11:54
Seen: 1361 times
Last updated: 14/12/21, 16:01