Posted by Nadine St-Amand on 05/28/05 11:59

pdt256 wrote:
> Anyone know of a management tool that will allow the expanding of
> one-many relationships in individual tuples of a table? Much like msoft
> access but in a web based format. I've created a simple php script that
> will read a database and do this simply, but I don't want to put any
> more effort to reinvent the wheel if I don't have to. It would be nice
> to have rollover effects that would reference any table that has a
> foreign key that references the current primary key in a table row. I
> think access implements a plus/minus tree for one-many relationships.
> Hope that explains it...
>
> -JI
>

Its not with rollover effects but it relate the data of many tables
using tables naming (exemple letter and letter_article and putting
id_letter into letter_article table)

It means that my engine generate related forms so that when you click on
a letter, you get a list of articles that relate to this letter and a
form to add a new one.

Then you get a simple layout and all the forms needed to add/delete/edit
and the menu needed to navigate between the datas.

http://www.phpbackend.com/create_database.php
For more info on integrity constraint of mysql:
http://www.phpbackend.com/one_to_many.php

Nadine St-Amand
nadine@coloria.ca
info@phpbackend.com

[Back to original message]