open files

[Josef_Kr]

I want to create a database for ebooks. I want to be able to open each book by simple pressing a button. Each book has a different type like txt, pdf, html etc. The file should open with it's own creator application. I am grateful for any idea. Thanks.

[Llaamaboy]

Here is an idea that might get you started.

In its simplest form:

One table

Each record - Name of Article, Date, Author, Subject, File (Link), ID

Layouts - Entry - Search - List all

Entry Layout is mostly straight forward.

Subject may want to be an editable value list and the file is a "container" field holding the link.

Navigate to List all, so you can see all articles, the find layout to search for a book.

List all layout would allow headers to resort data (simple option in table view (I think)) You may want the list all to open into a new window so you can easily input data into a search layout.

This, of course does not answer questions relating maybe an authors table to a file since one aurthor may have many names or the possiblity of two articles with the same name. But your scope is pretty limited, so a one table DB could be a good start for you.

In any case I hope that gives you some ideas. There are some real masters around here and I must tell you that I am only on my 4th real working DB, so Im a newb myself.