Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sequential Autonumbering ?

Sequential Autonumbering ?

Sequential Autonumbering ?


I know it is possible to start auto-numbering at a defined number (ie. start numbering from 1000).

Is it possible to auto-number starting from the auto-number in another table?
For example:

I have some Owners which own many Apartment Buildings which have many Apartments in each building.
Is it possible to begin with auto-numbering the owners at 100? Then in the Apartment Building table have the auto-numbering begin at 100; to give me an ID number of 101101 for the first Apartment Building belonging to the first owner. (The first three numbers indicate the owner ID and the last three indicate the Apartment Building ID) and so on...
Does this make any sense?

Any help would be appreciated.

RE: Sequential Autonumbering ?

Actually, this is what relationships are made for.

OwnerID  (Autonumber PK)

ApartmentBuildingsID  (autonumber PK)
OwnerID  (foreign key to tblOwner)

You would create the Owner/Apartment Building code by concatenating the two IDs in tblApartmentBuildings.  You could do this in a query and base all your forms and reports on it.

Hope this helps.  If you need more explanation, just ask.


RE: Sequential Autonumbering ?


I was wondering if you could expand on your explanation of how to attach two primary keys.  One Primary key using another from another table for its construction.


RE: Sequential Autonumbering ?

When you have created your two tables, go to Tools...Relationships on the menu.  This is where you define your table relationships.  Right click on the empty area and add your two tables.

Click and drag from the OwnerID in tblOwner to OwnerID (must be a number of long integer type) in tblApartmentBuilding.

A dialog box will pop up, to define the relationship.  It should say One-to-many and you want to click all the little check boxes about cascase updates, deletes, etc.  Click OK and you're done.

Now if you create a form, using the form wizard, and you choose the owner info from tblOwner and the Apartment info from tblApartmentBuilding, Access will create the form and subform for you, in other words, you will have a main form with owner info and a subform containing info on each apartment building that owner has.  If you enter info on a new apartment building, it will automatically be associated with the owner on the main form.

Hope this helps.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close