>
How can I fake out the report so that it puts the Fire Station headings under the correct Cities group when there is no detail record for the Fire Station in the Cities table?Howabout using the RAND() function? :-)
Seriously, it sounds like you've inherited corrupt data, and it's my opinion that VFP can not (honestly or accurately) invent a referential link where none exists.
You could build a report cursor from the two tables, and for Fire Station records with no city link, place 'Unknown' in a CityName field.
HTH,
Randy Bosma
VFP - Because life is too short to code in something else...