Joseph31 Posted June 2, 2004 Share Posted June 2, 2004 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 Link to comment Share on other sites More sharing options...
dbruggmann Posted June 3, 2004 Share Posted June 3, 2004 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 Link to comment Share on other sites More sharing options...
Joseph31 Posted June 3, 2004 Author Share Posted June 3, 2004 ok...i got it...but can i somehow put the additional 10 fields over the other fields already on the layout?... Link to comment Share on other sites More sharing options...
Ender Posted June 4, 2004 Share Posted June 4, 2004 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7267 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now