Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cleanup issue?

Status
Not open for further replies.

oscarse

Programmer
Apr 9, 2006
99
CA
I just built a simple address book with a dynamic search form and now have a problem with a field that won't clean up. When a table is created it creates an ID autonumber for the primary index ... normally I go and rename this field ... not sure what I did this time but none of my tables have and ID field yet the documentor says I have an index for ID ... plus my subform has both a linkmasterfields and linkchildfields attribute set to this non existent ID field???

Anyone have a way to cleanup these rouge references?
 
I found the link refences in the subform properties ... this may be the issue as the form is now working
 
ID 1
Clustered: False
DistinctCount: 2
Foreign: False
IgnoreNulls: False
Name: ID
Primary: False
Required: False
Unique: False
Fields:
SAID Ascending

So this is still in the documentor ... the SAID is the field but the documentor thinks it is ID??? Compact and Repair has no effect???

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top