in my listings by name layout, i want the category field to reflect all the different category values associated with a particular memberID. i thought i would want to use a portal for that, but it doesn't seem to work the way i set it up.

can someone help me out?

thanks so much

db

GLCCtestdatabase.zip

It is in the layout. Make the portal a little longer. Make the field a little shorter. Move the field down an to the right to be sure it is inside the portal row.

right on...i guess it's hard to see exactly where the box is laying. but now i see that all the listings are showing up. how do i get the portal to not duplicate category values?

thanks

have a beautiful day

Eliminate the duplications in the related table. A portal will show every related record.

that's what i'm asking, how to eliminate duplicate category values? different listing records may have the same category value, but i only need each value to show up once in the layout.

i don't need to see how many listings someone has in arts & crafts, just that you can find their listings there.

thanks

db

From what I see in your example file, these are exact duplicates. What is the purpose of have these duplicates?

If you can't remove the duplicates, you could create a value list of category based on related records. Then you don't need a portal.

See the attachment

i'm sorry, i can't seem to open the attachment. could you try again?

thanks

db

Have you expanded it?

the term i'm familiar with is extracting the files. is there something else i'm supposed to do other than use my zip program? because that didn't work

thanks

db