I have a field that when accessed displays a pop-up list linked to a field in another db.

But when clicked it displays the value list across the screen with some long records truncated...the file contains about 130 records

Am I able to format the pop-up window...add spaces to the records...I know i can if I type the information using Custom Values in Edit Value List...but I don't know how to if I use

Values from a field...

Or should I try another solution?

Help please

Hi Stephen, and welcome to FM Forums! If you have a value list with 130 items and each one is very long, that may become very onerous even if you are able to resize it to your liking. I think that maybe you should try another solution. What, exactly, are you trying to do?

Jerry

Hi Jerry

Thanks...I've worked out I can't do it.

I'm setting up a school science faculty lesson programming database. The 130 odd records are the required outcomes that need to be addressed through teaching programs in (Australian) Yr 7 and Yr 8 (high school).

I had hoped to set up a system where the outcomes list can be viewed an appropriate outcome selected...which works for what I have set up so far...but the value list is cumbersome!!!

Stephen

Maybe you'd do better with a portal. If the 130 outcomes are not dependent upon anything else; that is, if every record would have the same list of 130 options; create a second file (or table if you're in version 7--please update your profile!) that contains two fields: One, a calc field named "ONE" which is a number field always equal to 1; the other, a text field which will contain your outcomes (in separate records, of course).

In the main file, also create a calc field named "ONE" which is a number field always equal to 1. Now create a relationship to the similar field in the Outcomes file. You can now put a portal on your layout displaying records from this relationship.

If you make the portal fields non-enterable and attach a script to the field that goes, basically, "paste the contents of the field Outcome into the field i want", you'll have something similar to a value list but a little different.

J

Thanks

Will try

SK