Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan SQL : Pre Sales :

Re: [jaspercram] questions about relational databases

Sep 13, 2002, 12:31 PM
604
Staff / Moderator (733 posts)
Sep 13, 2002, 12:31 PM
Views: 5844
Shortcut
Quote Reply
Re: [jaspercram] questions about relational databases In reply to
Hi,

In Reply To:
Does the system fully support many to many relations?
Yes, DBman SQL can handle the many to many relations.

In Reply To:
- When a user is at the overview page of an author, can I add a link to the list of books written by that author?
Definitely.

In Reply To:
- When a user is at the overview page of a book, can I add a link to the author of that book?
- When a user is at the overview page of an author, can I add a link to add a book by that author (so the user does not have to know/remember the author id)?
- Is it possible to add a combobox with all authors in the 'edit book' page? (I would actually use this for adding a combobox of countries from a table of countries)
- is it possible to only allow adding a new book from the 'add book' link on the 'show author' page?
Actually, it will gererate a drop-down menu from primary_table on related_table's forms (add, modify, search..) automatically. E.g: the author dropdown will be added in the book forms.

In Reply To:
- Is it possible to add a combobox with all authors in the 'edit book' page? (I would actually use this for adding a combobox of countries from a table of countries)
No, you might have to customize the code a little bit.

In Reply To:
- where can I find a demo of a database where relations are implemented as mentioned above?
Unfortunatelly, we have not released the relational version of DBMan SQL yet which we are still working on the manual, hopefully it will be done soon. But you can have a look at it on our web-site:

Admin section: http://www.gossamer-threads.com/...bsql/admin/admin.cgi

User: http://www.gossamer-threads.com/...dbsql/db.cgi?db=Book

TheStone.

B.
Subject Author Views Date
Thread questions about relational databases jaspercram 5927 Sep 13, 2002, 2:47 AM
Thread Re: [jaspercram] questions about relational databases 		604 5844 Sep 13, 2002, 12:31 PM
Post Re: [TheStone] questions about relational databases 		charly 5813 Sep 14, 2002, 11:35 PM
Post Re: [TheStone] questions about relational databases 		jai 5810 Sep 15, 2002, 4:34 PM
Post Re: [TheStone] questions about relational databases 		jaspercram 5786 Sep 17, 2002, 4:37 AM
Thread Re: [TheStone] questions about relational databases 		hennagaijin 5708 Oct 4, 2002, 2:40 PM
Post Re: [hennagaijin] questions about relational databases 		hennagaijin 5599 Oct 14, 2002, 8:52 AM