up vote 0 down vote favorite
share [g+] share [fb]

I downloaded this template from the Microsoft website Customer Database Support and as I checked the tables, the DB has a table "Customer". And I would like to add a new fields is it possible?

I tried adding it, but the "Property Sheet" of the the table Customer changes if I add a new field.

As I can see now, the general Table Property Sheet has a "[Customers].[ID], [Customers].[Company]" in the Order by. As soon as I start adding a field with a data type this one goes away.

I'm not sure if this would create a problem later on. Does anybody know why is this happening?

Thanks

link|improve this question
76% accept rate
You should really not be saving any ORDER BY properties in your table properties. If you want an ordered view of the data, use a query. – David W. Fenton Sep 16 '10 at 3:41
thanks but I'm not saving any "ORDER BY" properties. I'm trying to add a fields in the table customer. And if I add this "ORDER BY" changes. Is this normal? – tintincutes Sep 20 '10 at 12:48
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.