I've modelled it in DBDesigner4, when I go to export the SQL code, however, it gives me a "There are circular relations." error.
I know that I can get away with having a circular relation, but the program won't let me have the code!
So where is this circular relation occuring, and how can I fix it? (Model is attached)
Your help will be appreciated very much!
Okay you must select all the tables. Hold Ctrl and clic each one of them or press Ctrl+A to select all then export them again. Circular error ocurrs becase you are exporting only one table wich has relations. If the problem persist delete the relations and start over.