I have two tables, tblPart and tblFootnote, and I need to combine data from both of the tables. tblPart contains data for all parts available on a particular vehicle. Fields for tblPart are:
VID, MFG, PART_NUM, PART_DEF, DESCRIPTION, FN1, FN2, FN3, FN4, and FN5
Fields for the...