Relationship between two tables

I have a project with the following characteristics:

Mysql tables:

Table customers (cliente_id, name, email address)
Table processes (process_ID, processo_numero, Arquiquo)
Table clientes_produtos (produtos_produto_id, clientes_cliente_id)

The relationship between the tables is OK: insert page register successfully process data in the table and writes the process ID of the client relationship on the table without problems.

Page processos_results:
This page lists all the cases registered in mysql. The recordset process was created automatically with the DataAssist. I show the fields processo_numero and file to download, no problems. The customer need not enter into search forms for listing the processes as they are filtered by customer ID (variable section) and I have done tests and it worked.

ISSUE:

My problem is in showing a field with the NAME of the customer linked to the process in the RESULTS page.
What I have done to try to solve:
1. I created a RECORDSET_CLIENTES to display just the client (name) linked to the process.
2. I tried to follow the tutorial post "Display data from related tables in results" in the forum but had no success. I created the second Recordset (RECORDSET_CLIENTES). But it really did not understand the steps to create a form variable and then move the second Recordset (RECORDSET_CLIENTES) into the loop.

HELP:
1. Please I need help on this issue. I think the tutorial post which I refer is incomplete because it ends without solution
2. Where can I find a complete tutorial and well-documented and preferably with the screens. The DataAssist has many tutorials and what I found was a tutorial file giving a perfect explanation for how the relationship between the tables but does not show how SHOW (results), edit or delete related data between them.

Thanks,
Vinicios Nussemeyer

you need to use a join query to display the related data.
See the following site for details on joined queries:
sql_join.asp


if you need help creating the syntax for the join query, a tool like Navicat is a great addition:
mysql_overview.html

it has a visual interface for creating complex queries.

Thanks Jason,

but I wonder if the WebAssist has some tutorial to their customers as display data that are related to the three tables. As I said before: the tool "Relational Table Manager" works well for entering data in the table of relation between the two. But I need some guidance on how to do this with DataAssist because I am not PHP programmer but a designer and use the tools of WebAssist to streamline my development process and offer solutions better and better for my clients.
Thanks,
Vinicios

data assist doesn't have a way of showing the related data. you have to create the joined query to accomplish this.

The navicat tool I linked to before will help you in creating the query if you do not know how to create it yourself.

Thanks Jason,

I'm downloading the trial version of Navicat. I will make the process of displaying the data it then.
Thank you for listening.
Vinicios

you're welcome.