I have an address database that has a main table for my relatives, and a subtable (children) for their kids. Within the subtable, I have colums such as name, marital status, dob, and email. I would like to print this information on one report, where I list the main name, address, telno (thats the easy part), then under that info, I would like to list all the married children alphabetically, and then in another row, I would like to list all the unmarried children. Hope this makes sense....I'm racking my brains.
Ideally I would like to have 5 colums in my report. The first colum to display name info, the second to display address info, the third col to display telephone info, the fourth to display married children, and fifth to display single children. As mentioned earlier, I have the first 3 colums coded, its just that fourth and fifth colum. Do I insert code into the "Control Source"? Not sure how to bring in the data from the married and unmarried tables when the id from main table matches the mainId from children table.