Relationship between two tables
I have a project with the following characteristics:
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.
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.
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.
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.