Create Records Via Relationship?

[findinghungrysamurai]

I've made a very basic database with a very large amount of entries. From what I've done, I want to create two "spreadsheets" that display the the different values of two variables. For example, I simply want an ongoing list of all of the different entries for a field that I've titled "Authors." In attempting to do this, I tried creating a table ("authors") with a relationship to my initial database (something to the effect of "author"="author"). I have created this relationship and I want to automatically create records in my "Authors" table from my database, but I can't figure out how to do this. I've tried defining the field in my author table as the "author" values from the initial database, but that did not accomplish my task.

I'm sure this question is very basic, but the Filemaker help database has left me more confused than when I started. Can anyone give suggestions?

Best,

Brian

[Kurt Knippel]

Create a ValueList, displaying the values from the Author field, call it "Authors" or whatever.

Now create a calculation: ValueListItems ( status ( currentfilename ), "Authors" ). This will display all the unique values of the Author field in a single list.

[findinghungrysamurai]

Thanks, Kurt.

I'm having some trouble with displaying the ValueList as a stand-alone document. I can see how I can create the list in a field, but I can't get the ValueList to display as a chart or a spreadsheet.

Additionally, it doesn't seem to like your calculation (specifically the command "status").

Best,

Brian

[-Queue-]

Use Get(FileName) for version 7.

[findinghungrysamurai]

Thanks for the help.

Brian