I'm creating a report showing a list of names with a list of items belong to each name. I have 1 table, and 1 query, they connect to each other by FirstName and LastName fields. Another word, i have tblName with NameID, FirstName, LastName, DOB, and other fields. qryItem has ItemName, FirstName, LastName, and some other fields. I created a DE with a command named cmdTblName. This command is connected to table tblName and i grouped them with fields FirstName and LastName. I added a Child Command to this cmdTblName and name it cmdItem. This child command is a SQL statement select from the qryItem. And i defined the relationship between the 2 commands to be FirstName TO FirstName, and LastName TO LastName. On the report, i connected the DataMember to the cmdTblName_Grouping and display the report. The report looks like this...
FirstName: aaa LastName: bbb
FirstName: bbb LastName: ccc
That works fine. Now the problem is, i have to get an input from the form, so i have to write a query to do the same thing. How do i do that?