Possible to use something else besides ID field to track records??

[rthakral]

Good morning,



I am trying to find a way to track records via a service number that is attached to each record via it's internal data. Can I use the number that every single record has to use as a search feature instead of the ID number? I want to delete all of the ID fields from my DB. They are of no use to me because they're always starting at random numbers and it's throwing everything off. Sorry if I'm being unclear, the question just came to me and I'm still working it out in my head.

Thanks, any help would be greatly appreciated!!

[rthakral]

OR is it possible to use the ID field/ or the realty services number i was talking about as a number search feature? For instance, if I go to the edit/modify screen and click on the commitee table a blank commitee form comes up and I should be able to enter in the appropriate ID number or reference number so that specific record populates the form. How can this be done? I have no idea how to code and have a teensy bit of knowledge with macros. PLEASE PLEASE advise. This is a superr important part of my DB.

[RuralGuy]

You can search any field in any table/query so I'm not sure what problem you are having. AutoNumber PrimaryKey fields are great and do not get in the way. They are not for user consumption though and the user need never known they are there.

[rthakral]

i.e. I need to be able to search for record/realty services number: 25 in the denovo table - but i'm using the form view to do this, how do i locate it within the form view?

[RuralGuy]

If the denovo table/query is the RecordSource of your form then a .FindFirst will work, otherwise you will need to use a Domain function (DLookup...).