Very new so bear with me. I have QGIS loaded with a TIGER/Line Shapefile at the Block level for a County, and need to join other detailed CENSUS data various tables (which also have a Block ID to relate on) so I can see more columns in the layer attribute table, and work with those.
What's the best approach? Do I open the original shapefile set .dbf table , relate, add columns as needed, output as a "sweetened" .dbf and then import again to QGIS? Or can I relate another local geodatabase table (with only an ID, no other lat/long info) right inside QGIS?
Any thoughts on what a good data format would be best (.xls, csv, tab/text, .xml, etc.) for that second table?
I see other posts re: csv joins but wondered if that's the best way to go here?