I am trying to write a report in Access using linked tables.  The link seems to be working with the following exception.  The report I am writing requires each of the line items on a sales order.  I have linked to what I believe is the correct table, BKARINVL, but the only info I am getting does not give me part numbers and descriptions past line 1 and repeats them multiple times.
 
I have noticed two things.  The field bkar.invl.key doesn't make it over to Access.  The other suspicion involves the BKAR.INVL.CNTR field.  Do I need to set up something special for this?
 
Thanks for your help!

This looks like a primary key problem.
 
When you link the table for the first time, Access asks for the primary key fields (for you to mark them by clicking on them).  If you aren't accurate about this, when you look at the data in Access, you will think there are a lot of records that are duplicate.
 
For example, if you linked to a customer table, and chose state as the primary key, all the customers from Texas would appear to be identical records.
 
If you don't know the exact primary key field(s), you are better off not designating any in that initial linking to that table, then you don't get misleading results.
 
For that table, I think that the invoice number and one of the line number or counter fields would get you a true primary field, but choosing none is the safest way of connecting.
 
Hope that helps!