I have 2 tables and one table only contains 3 fields: AccountNumber, FieldID and then Fieldvalue. I put this table in a subreport. I want to grab first, lastname and Middlename from this subreport. fieldid 4=firstname, 5=lastname and 6=middlename and place it on the main report.

so on the main report I want:
AccountNumber, DealerID, FirstName, LastName, MIddleName and GrossAmount.

Any help please. I've struggled with this for awhile. (LINKS AT BOTTOM to sample access and crystal report)

http://img185.imageshack.us/img185/3825/subreportpl5.jpg



here is a link to test access DB:
http://www.uploading.com/files/D9FMNRB2/CrystalTest.mdb.html

here is a link to report:
http://www.uploading.com/files/Y05XIY0K/subreportTest.rpt.html

Nevermind.. I just created 3 commands for first, middle and lastname. Then left outer joined the commands to the main table.