the web front-end for your database

Editing Overview

The whole point of dbFront is to to make it easy for users like you to get access to your data so that you can find what you want and work with it.

If you prefer tutorials, we discuss finding your data in the tutorial Searching and Filtering.

Finding Data

When you open dbFront and select your database you will see a main menu that lists the most important tables in your datatabase at the top.  If your database is more complex then you may also see a menu named "Main" which will contain a complete list of all of the main tables.

As a first step in finding what you want, you need to pick one of the tables that matches what you are looking for.  If you are looking to update a customer's  email address then you would begin by opening the customer table.

Selecting a table will bring up a screen similar to the image on the right.  The image is from a sample database so please note that the names of the tables, columns and fields are all likely to be quite different from what you see in your own database.

To continuing with the example...  Once the customer table is open, then you can enter something you know about the customer in the search box located in the top right corner of the customer table.

Suppose you know the customer's first name, so you enter 'jane' and hit the Enter key to start the search.  If the search returns too many records then add a space and add something more such as the last name or area code ( e.g. "jane 206")  and hit Enter again.   Once you have found your customer then you can click on the row to view all of the details.

Keeping it Together

dbFront automatically shows you other information that is related to the record you chose.

In the example above you see an Orders tab because the customer is associated with a number of purchases.  You could open the Orders tab to see and potentially edit those purchases and the related information.

Making Changes

Once the record has been found then making changes is easy.   You can update the fields as needed and dbFront will notice the changes.  

If you attempt to leave the record without saving, then you will receive a warning.

Clicking on the button named Save Changes will cause dbFront to make a quick check to see that everything is correct and then finally save the changes  to the database.

If there is any problem then you will receive an error.  This can also be seen in the image at the top of this page.  You will be required to fix the error before you can save your changes.

Content you want the user to see goes here.
close