I have 2 tables linked by a one to many relationship.
I have a number of queries and forms using this information. No Problem.

I now go back to the tables one is OK the other has fields missing.
Design view displays the missing field.
Even the forms that use the 'missing' fields show the data in them bt the original table will not.

Has anyone else had this problem or know what is happening. Its probably very simple but its baffling me.

Many thanks for reading this.

Graham

Have you accidentally hidden the columns? Try Clicking the Format Menu, then unhide columns.

Hi Kryst51

Thanks for getting back to me.
No havn't donethat although I did think I might have at first. I just seems to remain a mystery to me like a lot of access

Graham

I have no other idea (Just a shot in the dark really), is it possible to post your db? Then I could play and see what you are talking about. But maybe someone with more experience than I has a better answer, and you could wait for that.

Are any of the fields based upon the 'Lookup' tab and then a listbox or combobox in the design view? (where the rowsource of the lookup table is possibly missing) Although this shouldn't cause your problem, it's the only thing I can think of other than the hide. I personally don't like to utilize the lookup tab.

You can also try deleting/relinking the tables if they are linked tables into a frontend.