Table in need of more space

[Joseph31]

Hello everyone..

I have a table named Policies...

I have about 50 fields on it...They all fit and looks somewhat nice (If I do say so myself ).

The problem is now I have to add about 10 more fields... But there might be a silver lining... On my layout there are 10 fields that only have to do with a certain company (meaning when I know I am using this company I use these fields..the fields have different calc for them along with field names...

The 10 I have to add are for another company all together...they have different field names and calculation for themm. I would put them on a seperate table but there are about 40 fields left that I use for either company...So if I were to put them on a different table...everytime I make a change I would have change two table not one...

So I was thinking If I could get some kind of scrip or portal that I could put over the first 10 fields...making them disapear or appear when I select the correct company that would be cool...

Help...

Joseph

[dbruggmann]

You can place a portal (with the 10 additional fields) above your original 10 fields, based on a relationship between the company selecting field and a global field, that contains the name of your

[Joseph31]

ok...i got it...but can i somehow put the additional 10 fields over the other fields already on the layout?...

[Ender]

Users will be overwhelmed by a data entry layout with too many fields. Use a tabbed interface. Study the FM example files to see how this works.