I have an Access 97 database with two tables, and I need assistance with creating a specific query. The first table ("Family") has the following fields: "AutoNum" (PK), "Last Name", "Street Address", "City", "State", "Zip Code", and "Phone Number". The second table ("Family Members") has the following fields: "Family Key" (related to AutoNum above), "First Name", "Middle Name", "e-mail Address", and "Nick Name". I need a query that will display the query's result in one row (record). The information (record) to be displayed is "Last Name" (from the "Family" table) and each "First Name" (from "Family Members" table) that is related to a specific last name.
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. An Access 97 Query that will display the query's result (described above) in one record. For example, if the "Family" table is populated with the "Last Name" values of "Doe" and "Brady" and related to these values the "Family Members" table is populated with the values "John" and "Jane" (related to Doe) and "Mike", "Carol", "Greg", and "Marsha" (related to Brady), I need a query that will display two records. The first record would be "Doe", "John", "Jane". The second record would be "Brady", "Mike", "Carol", "Greg", "Marsha".
## Platform
Windows 98