Assign Auto Id

[pthakar]

I am new to access and I have bldg. and lease tables. I have one form(bldginfo). I have to design something like this :-
A user should be able to pick building code/address or name from a drop list and on another form he/she should be able to populate the related leases on form fmlseinfo (one building may have multiple leases)
and if building doesnot exist then an auto loction code start with the consecutive number("OC001","OC002" and so-on) should be assigned automatically and user should be able to put information about that building name/ address etc,
Pl. help me..
I will appericiate you
May God Bless You.....

 

[psemianonymous]

I need 3 pieces of info first:

1. The table name all this is stored in
2. How did you come up with the "OC" part of "OC001"? Is the "OC" another field, or is it ALWAYS going to be "OC"? Just try and explain what OC means. If it comes from another field, name that field also.
3. What is the name of the field where you're storing the value "OC001"?

If I am to write the code for you, I need the specific field names and table names.

 

[pthakar]

Thank you for the quickie
By chance I click the check mark for the notification off So I didn't see this thread!!!
What I need to do is to define a unique code for each building.I have some buildings from other database identified as "DCoo1,Dc002,so on". The buildings which are not related to other database needs to be defined so that down the road we can differentiates. "OC" will be a identifier for local buildings(the 60 buildings I have in the tbldg table) and for formatting consistency we have to assign each building a unique id.
In future end user will have flexibility to add new buildings by himself.
Thanks again

 

[MichaelRed]

see faq700-184

MichaelRed
m.red@att.net

Searching for employment in all the wrong places