locked
Table schema creation for a dynamic screen RRS feed

  • Question

  • Hi All,

    I need to create schema for a dynamic screen. Highlighted row (RED) values are dynamic coming based on configuration settings of other screen but could more than three.(Between 0 to 3). Textbox are also coming if selected on setting screen.

    See the below screen.

     Can anyone guide me what is the best approach(structure) of table to save data with one reference key.

    Thanks in advance.

    Anuj

    Friday, September 29, 2017 8:45 AM

Answers

  • No - because a table represents a real "thing" in your data model. What it should not represent is your "screen". How you present data to a person has generally little relevance to your data model. Why? Because at some point you will find that you need to (once again) change how you present data - whether based on form-factor or preferences or some other considerations. Your data model doesn't change - just the presentation. 

    In addition, if the arrangement of information is driven by "configuration settings", then there is no "table" to be created for your screen. You might have a need to store these configuration values in the database, but the actual screen layout is driven to the configuration information. Perhaps you should consider how Visual Studio does this (but probably in a far simpler manner). 

    Your question is specific to your application and your development environment - how to dynamically define/arrange/drive a window and its controls. 

    Friday, September 29, 2017 12:00 PM

All replies

  • No - because a table represents a real "thing" in your data model. What it should not represent is your "screen". How you present data to a person has generally little relevance to your data model. Why? Because at some point you will find that you need to (once again) change how you present data - whether based on form-factor or preferences or some other considerations. Your data model doesn't change - just the presentation. 

    In addition, if the arrangement of information is driven by "configuration settings", then there is no "table" to be created for your screen. You might have a need to store these configuration values in the database, but the actual screen layout is driven to the configuration information. Perhaps you should consider how Visual Studio does this (but probably in a far simpler manner). 

    Your question is specific to your application and your development environment - how to dynamically define/arrange/drive a window and its controls. 

    Friday, September 29, 2017 12:00 PM
  • Thanks Scott for your response.

    That controls already created and showing screen on UI based on saved configuration details.
    But this screen have some textboxs so here requirement is to save those value in DB with associated value in database so user can see same details when he/she revisited this page.

    Thanks

    Anuj

    Wednesday, October 4, 2017 4:26 PM
  • Anuj, any update on this issue?

    Thanks!


    Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Wednesday, April 11, 2018 1:36 AM