Kamis, 05 April 2012

[MS_AccessPros] Major data issues.

 

Hello All,

I have just looked at the data tables I had built for a client and I am horrified. I had the table relations correct and the tables designed with PK's and everything. But as I look at the design, the PK's are not set and the related field data in each table is either missing or has a 0. They do not have the knowledge on what to do in the table design so I must have taken the PK off at sometime and did not put it back.

Somehow the relations have kept the records on the forms working but I am at a loss on what should my next move be. They did an audit and the records all match based on the forms, but the tables are a mess.

Any Suggestions

Jim Wagner

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar