should i be using a portal?

[kaosgds]

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

[RalphL]

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.

[kaosgds]

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

[RalphL]

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

[kaosgds]

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

[RalphL]

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

[kaosgds]

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

thanks

db

[RalphL]

Have you expanded it?

[kaosgds]

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