SQL & Relationships

[Toby_Rees]

Not strictly a PHP question (although my page is coded in php - thats fine though), but my guessing is that someone here will know the answer.

I'm doing a second year college A level database project. I've got 3 tables:
- tblcustomers
- tblstock
- tbltransactions

Each table has its own unique ID, my transactions table has a feild for both stock and transactions which need to be related to the respective tables. I've got no idea how to do this in sql unfortunatly! Is there a SQL program that can be used to do this with a GUI? Or will i have to write out the SQL commands, if so, anyone help?

I tried to export the database using preiumsoft SQL studio to MS access create the relationships and then import the data, but the relationships were removed when I tried to do that.

Any help would be appriciated!

[nemonoman]

You should teach yourself to do this: it isn't hard at all.

For background reading, try my thread:

On relational databases

THere are expensive tools that provide GUIs that build CREATE TABLE statements. Simple tools like PHP admin will write the SQL if you know just a little...which you might get from reading the thread above.