Help me Please Lindsay
|
| Posted: 09/03/2002, 7:39 PM |
|
I want to have multiple tables but search have results display in a grid How do I join them I am so confuesed. Using CC with ASP with Microsoft Jet...
I do not even know if my verbage is right any help in the right direction would help.
Lindsay
Dorkrina@hotmail.com
|
|
|
 |
WilliamB
|
| Posted: 09/03/2002, 10:02 PM |
|
If I understand you correctly, you want to have a grid display fields from multiple database tables after a search. If this is the case, the SQL tab of Form Properties window has a field for Custom SQL where you can enter a SQL query that has joins. What I usually do is write the query in the database and test it then copy and paste it into CC. After adding the custom query, you can use the Input tab of the form properties window to specify the input parameters that will be received from the search form.
|
|
|
|
|
