In Q&A you could create a Keyword Report (the separate items in a Keyword field would each get their own line on the report). 

How can I accomplish this with Sesame?

   Robert

But the main point of the Q&A Keyword report was to print out ALL information in a Keyword Field. 

I have used it for years to create a "list" of information included in a single article.  Then I keyword report it, and I have an instant alphabet sorted index.  My last printout was a 3 column 100 page index of 25 years of information.   

Could someone create a "program" to do this, since Sesame can't?

   Robert

I agree that Sesame should do this (it is the only reason I stuck with Q&A all of these years over everything else available).

Here are 3 sample records.  For my usage, I use a combination of the first few fields to select the records, then I "Keyword" the last field "Contents" for my main report.   

"MailingNbr","Pages","Author","Title","Contents"
"9","4","Gilliam, Rick","Miscellaneous Review V2 #2","Miscellaneous Review V2 #2 (Gilliam) (9,4); Baseball Players from Alabama (Gilliam,MR2#2) (9,4)"
"39","6","Burkert, Tom","Indexes Unlimited #30","Indexes Unlimited #30 (Burkert) (39,6); Baseball in the Movies (Burkert,IU30) (39,5)"
"49","10","Nolan, Michelle","Newsstand Dreams #06","Newsstand Dreams #06 (Nolan) (49,10); Sports Comics Index, Part 1 (Nolan, ND6) (49,9);Amazing Willie Mays, The nn index Nolan,ND6) (49,1); Baseball Comics nn index (Nolan,ND6) (49,1); Smash-Hit Sports V2 1 index (Nolan,ND6) (49,1); Baseball Thrills 10,2-3 index (Nolan,ND6) (49,1); Football Thrills 1-2 index (Nolan,ND6) (49,1); Bill Stern's Sports book 10,2-3 index (Nolan,ND6) (49,1); Mel Allen Sports Comics 5-6 index (Nolan, ND6) (49,1); Pride of the Yankees nn index (Nolan,ND6) (49,1); Home Fun 3 index (Nolan,ND6) (49,1); Swat Malone 1 index (Nolan,ND6) (49,1); Baltimore Colt nn index (Nolan,ND6) (49,1); Sports Thrills 11-15 index (Nolan,ND6) (49,1)"

Yes that is what I want Sesame to output.  Current output from Sesame is just 1 line with an entire keyword field's contents on that line.   So how much massaging of the data outside of Sesame is going to be required?

BTW, I do appreciate your help on this issue.  Thanks.

   Robert

One more new thought:  To stay with Sesame, and not need to use another program like Excel, consider this option.

Rather than importing to Excel to do the sorting, you could import into a special, single field, database within your Sesame application.  Then you could retrieve all the records in that database, sorted, and then run your "KeyField" report from Sesame.

Now that we can do all of that within Sesame, then we should be able to make a Sesame macro to do that.  Once the macro is made, we can now create a function to run the report, or add a button on a form to run the KeyWords report which will call the macro.

I like it.
Now you have the roadmap, just need to take the trip.   Enjoy!

My suggestion to import into Sesame may need some more work.  I was thinking of importing a file that had all KeyValues, fields, and records separated by a semicolon since that is what you use in the KeyField.  But Sesame does not currently allow imports using semicolon as a separator.   It will only accept comma delimiters.

And you can still do a combination.  Import the semicolon delimited file into Excel.  Then you can export from Excel into a "Quote-Comma" delimited file, because no more semicolons will exist.

So until Sesame can import with semicolon delimiter, you will still need to use something like Excel, unless you follow my second suggestion to add a KeyWord record on the fly as you enter records in your main database.

It's on the list of possible features for future versions.