1: Show in an Another table only The author, title, year and subject.
Other than the reduced number of fields, How with this "other table" differ from the first? (A layout can simply list records from your current table but only use the fields you specify and this would not require another table to do.)
2. Enter find mode, specify "cooking books" in the subject field and perform a find. Then sue Save As Excel or Export Records to export the data to an Excel file. This can be scripted so that you can specify a subject from a drop down list, click a button and the excel file is produced.
3. Web Direct requires fileMaker server. If you host your FileMaker Database file on FileMaker Server, you can then make the database available to other users via their web browsers if you use WebDirect in that context.
Thank you so much Phil. Your reply helped me a lot.