Hi everyone, I'm new to this so bare with me.
 
We are thinking about exporting DBA tables into Access in order to generate more useful reports. I have never done this before and I was after some helpful tips and advice.

Thanks for your help 'Skeptical'. That idea sounds much better than want I was going to do. Do you know how I go about getting the ODBC DSN setup? Would I set that up from within Access? I also have no idea how I link the tables together with DBA. Is there an option meni within DBA to do this? Sorry for all this questions I am very new at this. Thanks again.  

Thanks for the link to the web site. This is probably a stupid question but do I have to use Pervasive to be able to use Access?

OK thanks that makes sense.

Yea I am at long last. Thanks again for your help, it all seem so simple now I've actually done it. lol.
 
I do have some other issues that you may be able to help me with:
 
Background: I am trying to use MS Access to generate a report which is similar to Invoice IBKSOF4.RTM with a few extra fields and a different design.
 
1. I am having difficulty finding the table which contains the 2nd line description for an Item which is entered in DBA on IN-B. I can find the 1st line of the description in BKARINVL table and most of the other information on the DBA report but not the 2nd line description. This must be stored on a different table does anyone have any ideas where?
 
2. In DBA the IBKSOF4.RTM invoice report shows serial numbers related to each Item which I am trying to display in my Access report, but I can't find the Tables which hold ALL the serial numbers. The DBA SERIAL  table holds some serial numbers but not all of them that is displayed on the DBA invoice report. I have looked in the MASTER Serial table which I hoped would display all serial numbers but it doesn't. Does anyone have any ideas which tables I can look in?
 
3. Any finally in table SERIAL there are multiple serial numbers for the same item and these duplicates are not displayed on IBKSOF4.RTM. In Access does anyone know how can I display only each unique serial number and not all the other duplicates?
 
Well I don't know if anyone can help but I would appreciate your comments. Thanks.

Thanks.
I always reprint previously posted invoices. Can you help with my issues?

Wow thats great and such a quick response - Thanks!  
I will check out the description info. shortly. Yesterday I actually tried to use BKSOHSER table and I found two problems:
 
1. Not all the serial numbers on IBKSOF4.RTM invoice report in DBA appeared in the BKSOHSER table. Is it possible there is another table that is been used to store the other serial numbers?
 
2. There were many duplicate records for each item in BKSOHSER table. Is this a problem with the way we have setup our system and if so then do you know how we can rectify the problem? If not does it normally have duplicates and why?
 
Thanks again for your help Lynn.

You should be looking at the BKSOHSER by invoice number so you should only get the serial numbers associated with a given invoice.
 
If an item has a second description line in IN-A then the BKIC.PROD.NOTE in BKICMSTR will have that information.  Linking to the BKARHIVL table will be trickier because it is not the same record as the line item - it is the NEXT record in the file.