Is there a way to get more than 2 fields in a value list. For example:

I have a popup list linked to a value list. That value list is looking up 2 values from another table.

When I click on the popup I only see those 2 values. Is there a way to add a third or fourth?

Thanks for your time

I have tried this possibility several times before. I have not been able to come up with any satisfactory results so far. I could get the pull down to list three (or more) items, but the actual "selection" gets confused and doesn't perform correctly. What I did was created a calculated field that concatinated two other fields I knew would have SOMEthing in them. I then used this calced field as one of the displaying fields in the value list.

I'm beginning to think this isn't possible. I would be VERY interested if someone has come up with a method that works.

as in 3rd and 4th "column" inyour list?why would it be possible?

otherwise they would be called "value tables" not "value lists"

I am sure u can resolve your issue with related value lists....or did I read this wrong?

What I'm talking about is trying to show more than two values when you select a popup bar.

For example: I have a list of 4 values. Each item in the database is given an ID #. Each item in the database has info in the 4 columns that show up. Many items may share the same values in column 2, but may have different values in columns 3 and 4. To simplify this I reference these items from there numbers. Problem is, when I select the popup bar, in colum 1 is the reference # and column two is the info in column two. Since column 2 may have the same value for many records I need to also see the values in column 3. I hope this doesn't make this more confusing.

Seems to me it would be useful make the field into a button that opens up a table in a new window instead of opening a pop-up value list.

The table layout can have whatever columns you want, along with a button that appears next to each record. On pressing the button to select that record, it places the ID# into the original field.

Of course, I you knew my level of knowledge, you might suggest I read more instead of writing.

LOL BruceJackson!