I have a personal geodatabase that I have been working with for awhile now. I want to add two fields to a table; SignRating and SignShape for street signs. I want both to be drop down menus so I created a coded value domain for each; SignRating has values from 1 thorugh 5 and SignShape has a list of the various shapes signs can be.
SignShape was working up till a couple days ago when I noticed the field was gone. I tried adding a new field, but I only get the drop down menu on new records I add. I have over 2500 records and I don't really want to go back and type in the sign shape for each one. The field doesn't come over at all when I check the data out with ArcPad on a GPS.
SignRating also only gives me the drop down menu for new records I add on the computer. The field comes over to the GPS but still doesn't give me the drop down menu with values from 1 to 5. I have to choose <Null> every time because it says the default value is invalid and <Null> is the only option on the drop down menu.
I tried starting over and I deleted the SignShape field and tried to delete the domain but I get an error saying "The domain is used by an attribute rule."
