Access tables behaving like queries!!!

[BenJones]

Hi,

I'm a bit puzzled with this so hopefully someone can help me out. I have a database that has around 20 users who key on their vehicle orders. The main orders table has a number of fields. I have started to notice that the 'Order Date' field that gets populated on completion of the record is now blank on almost half the records. (I have retrieved an older copy of the DB and the dates are there, so they did get input at one point). Further more, I have another field called Business Group which is a look up to a linked table. The Orders table is showing the records in Business Group Ascending order for some reason rather than by the primary key. And finally, when I open the table a progress bar appears at the bottom of the screen stating 'running query'. It seems my main table is now behaving like a query and is losing data.

Anybody got an idea what's going on?

And yes I have definately checked it is a table. Im using 97

Cheers

 

[MarkK]

Hey:
1) I'd default the OrderDate at the table level to make sure it gets entered.
2) If you have a field that runs a lookup, that's a query. If that query takes time to run then that's your progress bar. If that query sorts the result set by something other than the primary key, then...
...in table design view, see the lookup tab, lower left, for the field in question.
3) Seems a safe bet that 1) and 2) are not related.
Cheers,