Linked table and missing records 1

[MikeGeitner]

Hi,

I'm working on a database that uses linked tables. For starters, I'm only linking to one table called "Material" that is in our enterprise database (JobBoss). It's a list of all the part numbers we manufacture. I noticed that some of the parts are missing from the table. But if I use Crystal Reports on the same table, all the missing part numbers show up. Anybody know what's happening?

Thanks,

Mike

 

[PHV]

Does access recognize the PrimaryKey of the linked table ?
Does Crystal Reports use the same ODBC driver ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MikeGeitner]

If I goto "design" on the table, the primary key shows.
Don't know about the Crystal driver, yet.

Mike

 

[MikeGeitner]

Got it. I had to start over with a blank database, "get external data", then "link tables", choose an ODBC database, click the "Machine Data Source" tab and choose the "JobBoss" database. Don't know why I didn't start with this but.................