When creating two tables with one referencing another the 3rd table (lookup table) has reversed foreign keys.
I.E. I have two tables: Store and Employee. Both an employee and store get a unique guid. The table that gets generated as a look up Store_Employees has two columns (store's guid and employee guid). The foreign keys on these fields are reversed. So that the store guid is a foreign key to the employee's table guid and vice-versa.
Let me know if you need more details to replicate this.
Posted 13 Oct 07
Great site. I really enjoy using it well worth at least $10 to me. Couple of thoughts: Is there away to change the depth (z-index?) of any of the classes I'm making? Also to help facilicate faster input, can you make a short cut to the Add field button. Slows me down having to type the field name, hit enter, then the first letter of the type (nice short cut by the way) and then have to manually click the 'add + ' button.
Also I think it would be handy to have a way to drag a table header to a column header of another table to specify a "many-to-one" relationship automatically.
Posted 13 Oct 07
Total Messages: 5
Topics Created: 1