Welcome, Guest   [ sign up ]
Translate Text
Name Generators
Storyline Ideas

Online: 0 members, 65 guests

Log In![ sign up ]

    submitted 04 November 2006 @ 15:51
    edited 02 January 2010 @ 14:20

How to create a FR Database (Part II)

Article written by Tobias Woulfe
Rating: Superb! (5) (5 rating, 3 ratings)

[ article listing | post comment | view/offer feedback (0) | rate this article ]

Welcome to the 2nd part of the FantasyRole Database Tutorial. It is suggested that you understand the basics of creating a database which were discussed in Part one. You can find it here. This part of the tutorial will focus on the creation of multiple field Databases and databases within databases, using the Among the Stars Databank as an example.

Alright, we will begin by showing and explaining multiple field databases like the one below:

Inserted Image

To put it simply, a multiple field database allows you to have different columns with unique data in each, like a table.

1) Begin by going into the group manager and into the Database section. Create a new database like was done in Part I (The style selection isn't important yet, that will be explained later).

2) Now you've got a database with a single field. Adding fields after this is fairly simple. Just double click add new field over in the little box to the right of field definition. Types are fairly self explanatory; text is a limited amount of text, memo is unlimited text, numeric is only number, yes/no is only yes/no, etc. The required check box means that you can't add an entry into your database without filling out this field for it, you can choose that option depending.

3) Listing/access is important when you get into more detailed forms. However column order is still important. This is where you specify the order you want your fields to be in, that way you don't have create your fields in a certain order, you can just specify it after the fact. You'll notice that it says 1 is on top and 100 is on the bottom, and we'll get to this in a moment, for now though they will actually be across the top, not on the side (Specify between 1-100, with 1 being on the left and 100 being on the right).

the field read/view and right access simply means that its getting those properties from the main database settings. You can specify certain fields to only be visible for certain people such as group members only, or only editable by group members.

4) Now simply follow the same steps as in Part I to post the database. Then go to view group, and find the database under group options. Again you'll notice there are no records yet, however there's that little button add record, click it. Now, a page similiar to the one that came up with a single field database will appear, however there will be multiple text boxes (or other types depending on what you set the fields as) for you to enter data into. You won't be linking files this time, instead just put the data directly into each field. Generally it should be kept fairly short. Click add new record and your done! You've create a simple multi-field database.

Database creation -detailed view

Now its a really short jump from this kind of database into a database like this:

Inserted Image

Where clicking on the Name (or other field so designated) will bring you a more detailed entry as shown below:

Inserted Image

5) Remember that part back under field creation in the Database section called Listing? There were three options; In listing, Link to Detail, and Not in listing. So far we've only used the first one. Now we'll use the others. (The style of the database (back when you created the database) should be Listing with Detail)

6) A field labeled link to detail does just that. This field will act as a link to the detailed layout shown above. (You'll notice that the detailed page is where the fields are arranged as rows, so this is were the order with 1 on top and 100 on bottom comes into play). However, if you simply have a link to detail field and a few In listing fields, you'll notice that the fields are shown on the first page, and then again on the second page; there's no more detail shown in the detailed view than if you were looking at the entire database view.

7) That's where the Not in listing comes into play. Listing refers to the basic overall database page, where the records you add are essentially listed. If a field is designated as Not in listing, it won't appear on this first page, but it will appear in the detailed view.
* * * * *

Now you have a fairly detailed database set up to play around with. Have fun with it! You can use the single field Database to create links to more detailed databases (create a few databases, get their urls, and then use the href function to link to them from another database) like the Among the Stars Databank or figure out and explore the other options on your own.

I hope this has helped you with understanding and building FR databases. Most of the information above is now available on the various pages used to create Databases (A big thanks to the site mods for that), and that should help you on your way, without needing to refer back to this tutorial. If you have any questions concerning this tutorial or Database/group options in FR, feel free to send me a private message through FR.

Post your Comment   [ view feedback comments (0) ]

Your Name:
Authorisation Authorisation Imagery--if you are partially sighted/blind and cannot see this image, please contact an administrator ( Please type the numbers you see,
in order, into the box:

Rate this Article

Other Articles by this member:

How to create a FR Database (Part I) Rating: Excellent (4.5)
    26 September 2006 @ 00:07

Member Articles Average Rating: Rating: Excellent (4.5) (4.5 rating)

[ article listing | post comment | view/offer feedback (0) | rate this article ]

©, est. 2014