I am the resident hack here that likes better reports than what DBA innately offers.  I have deveoped many excel query reports and recreated the 'Accounts Receivable' -> "A - Enter Customers" -> "Edit Existing Customer" GUI in Access.  However, i am having extreme difficulty in understanding the relavance of some tables for creating a report with information form several tables: Company Name, State, Sales persons, Credit Hold, <- I think this all comes from BKARINVI.  The other stuff i need is the individually sold items like in BKARINVL (PCODE, PPRICE, PQTY, PEXT, ASD.  I can not figure out how to link the two tables.  Any clues?  I'm not set on using those tables, just getting the data so i can see a particular product's sales by state or customer and also looking at a sales person's accounts and their performance by month.  I want sales only from last 2 or 3 years and i can certainly make it a query and return it to excel.
 
Here are my current queried fields, which don't work entirely:
BKAR_LASTSALE      BKAR_SLSP_NUM_1      BKAR_SLSP_NUM_2      BKAR_CLASS      BKAR_CREDIT_HLD      BKAR_INVI_PCODE      BKAR_INVI_PQTY      BKAR_INVI_PPRCE      BKAR_INVI_PEXT      YEAR      MONTH

Tim,
Thank you for that quick and clear solution.  Is there a whitepaper or something that explains what each of the tables are and what the fields are?
-Nathan-

Thanks Kelloggs for writing out the query for me.  It's nice getting this warm welcome so quickly.  I'll have to do some reading on your method.  It sounds much more efficient than linking the whole table.

Woo Hooo!!!  Data Map! Yeah!  This is sweet!  You guys have made my day.
I am working on one oterh project.  We need to create a different packing slip and Invoice for a certain customer.  The heater needs to be different so it does not show our company name.  Does anyone have experience changing or creating these?