Show all titles in the database in a portal

[booksguy3]

I'm overlooking something. Years with filemaker (Version 3 my first) but never used portals. I'm not a programmer either but have done ok on my own. SSsssooo,

I sell books. Each record is a title. I want all titles to show in 1 field so I can copy paste or send in emails of current availble titles. I have tried my relationship but can't seem to get them in there....HELP!!

[QuinTech]

Hi guy, and welcome to the Forums!

Try this; Make a value list whose items are based on the field theRelationshipName::bookName. If the relationship and value list are constructed correctly, you should then be able to make a field use a popup list that shows all books.

Taking it one step further, make a calc text field equal to ValueListItems ( Status ( CurrentFileName ) , "valueListName" ), making sure it is unstored. This field will then display all the books' titles.

HTH,

Jerry

[booksguy3]

Thanks. The Value list worked.......but. I have duplicates of several titles because I sell for some other people too. I found that it did only show one title instead of duplicating it. But I have about 4 lines that show only the "by ..." as shown below. Any idea why???

Broken : The Troubled Past and Uncertain Future of the FBI

by Ina Garten

by Jimmy Buffett

by PAT CONROY, SUZANNE WILLIAMSON POLLAK (Hardcover)

by Richard Gid Powers

by RICK RODGERS (Hardcover)

by Timothy Greenfield-Sanders (Hardcover)

Celebrations 101

Thanks for the help,

Bob