Table Design Confusion

[Dabaum]

I am experienceing another problem with my replicated BE. Last Tuesday
things were working fine, but Friday one of the tables that we query for
information through the FE started displaying it's data with
non-corresponding ids. (data mix up?)

So Friday I spent some time looking at the codes and the Relationships
design. Didn't find anything suspicious. Then I found some code referencing
a "propertyid" field from a table. I was relieved and thought I had found my
solution until I opened the table and found that the field "propertyid" does
not exist. I right clicked to unhide tables fields and it wasn't listed as a
hidden field.

Then i did a query on the table Select * FROM tblIssues. Suddenly the
"propertyid" field shows up.

Anyone know why this happens?

 

[David F Cox]

it might be a field with a caption property set that is causing confusion.

 

[John Vinson]

I am experienceing another problem with my replicated BE. Last Tuesday
things were working fine, but Friday one of the tables that we query for
information through the FE started displaying it's data with
non-corresponding ids. (data mix up?)

Try deleting the link in the frontend and using File... Get External
Data... Link to relink to it; or compact the frontend; or restore the
frontend from a backup - or any combination as needed. Sounds like the
link to the backend has gotten corrupted.

John W. Vinson[MVP]

 

[Dabaum]

I checked the captions, and they are all blank. When I look at it from
design mode there are three fields, issues_id, issues, and issue_date. Only
when I run the query do i get the fourth field. I think it might be a
corruption issue since I'm dealing with a replicated database. That hasn't
had any maintenance since 2003.

 

[Dabaum]

Try deleting the link in the frontend and using File... Get External

Data... Link to relink to it; or compact the frontend; or restore the
frontend from a backup - or any combination as needed. Sounds like the
link to the backend has gotten corrupted.

John W. Vinson[MVP]

If it was a bad table link would it reflect in the backend?

I think I am going to reconstruct the tables in a new database to be used as
the BE.
Thanks for your help
Brandon