AnsweredAssumed Answered

Grid view with join records - methods?

Question asked by Mike_Mitchell Expert on Nov 2, 2016
Latest reply on Nov 2, 2016 by beverly

Good day, all. I'm in the process of upgrading an application to .fmp12 format from .fp7. The original app was written by someone ... not particularly adherent to normalization principles.  

 

Here's a partial screen shot of the original app:

 

2016-11-02_8-47-58.png

 

As you might guess, each box you see is a separate field. Ouch. When I remodeled this, I turned everything into a join table using a portal, but I'm not happy with that interface. It results in a lot of scrolling. So what I'm looking for is a way to model a grid like this without having huge numbers of fields in the table.

 

Ideas I'm considered:

 

- Repeating global fields w/scripting to populate actual records

- Single-row portals for each box

 

Neither of this is particularly attractive to me. Anyone have any other ideas?

 

TIA

 

Mike

Outcomes