Sometimes you need to connect two tables together. In this way you would use relational tables and assign primary keys and foreign keys. Then you'd "join" them together in your recordset so that when you ran your query, you'd have info stored for both available.

The purpose for all of this is to optimize your tables. Therefore a change made in one location could be updated globally eliminating tedious work.

In this example, you have set up a table for venues for orienteering site. Each venue is set up with a venueID.

In your events table, add a new field after your eventID. This field will be your foreign key. Give this a name of event_venueID, MEDIUMINT, 8 length.

The naming convention of first_secondID means that first is the prefix of the table name your in. Second is the original table your relating your table to.

Now in your table, you can give a number value to each event_venueID. Example, Vasquez Rocks = 1, Griffith Park = 2, Long Beach = 3.

Now when you enter new records, you can put the value of the event_venueID and therefore your relating it to the venue location in the above step.

You can enter more event records now..as many as you like. As long as you assign a number specified for your event_venueID, it will always know what venue you are linking that record too.

Adding new binding fields into your .php page

After your join, you will have all the binding from your events and venues tables.

You can add a new binding from one of the tables into your .php page.

Change your SQL Query.

Click on the bindings tab to open the existing query.

Click on the advanced button.

You can use the dreamweaver buttons to write the following query:

SELECT*

FROM events, venues

WHERE events.event_venueID = venues.venueID

In the WHERE statement, you are relating the foreign key to the primary key.

Hit test will show you the results of your query.