Using Dreamweaver MX2004, PHP, MySQL, I have to create a principal page using
fields of 2 tables and a detail page using fields of the same 2 tables (more
fields on the second page of course).
I have no problem creating the principal page. I have problem with the detail
page.
The link between the 2 pages is OK for all informations of the first table but
I do not manage to get the good information for the fields of the second table.
ex : the principal page is using 3 fields : Name, description, price of the
table "Articles" and 1 field (nameenterprise) of the table "enterprise".
The detail page is using 4 fields (name, description 1, desription 2, price)
of the table "Articles" and 5 fields of the table "Enterprise" (nameenterprise,
adress, tel, fax; mail)
I created a recordset with a link between the 2 tables
(Articles.enterpriseID=enterprise.IDenterprise).
The link between the 2 pages is based on the article's Name with a key on
IDarticles.

Results : the principal page is OK (the articles and the enterprises are
matching), the articles are OK on the detail page but the enterprises do not
match with the articles selected on principal page.

Can you help me please.