Auto generate sequential number

[krai]

<sup>Auto generate sequecial number based on another table entry in a dropbox.


Building 200 201
building 200 202
building 300 301
building 200 203
building 300 302
so the drop down box is building number.
and it generate a new table entry based on the building number and sequential in the last to didigits</sup>

[orange]

krai,

How about telling us in plain English WHAT you are trying to do?
table, dropbox, auto generate is all jargon-ese.

I have a project involving buildings......


For reference, readers don't know you or your environment and can't start to offer focused advice until they understand your situation.
Tell us as you would tell a child
-what you are trying to do
-the major things involved
-how these things relate to each other

Jargonese is not the path to good communications.

Good luck with your project.

[krai]

I am building a database for packing, what we put on pallets, with pallet numbers and where they go to, and to print out a item list with containing items, serial numbers and weight that tell where the pallet goes.
I just used an example with buildings.


Pallet number where the first digit of 3 (3xx) for example goes to a certain location lets call this (New York) and the next to is auto generated in a numeric order.
301, 302, 303 and so on. so when I press a button I make new pallet I have from a drop box a list of locations to chose from and it generated a new pallet number in numeric order.

[orange]

Better!
How do you know which items go with the pallet, the weight, serial numbers etc?

Seems you are dealing with:

Items
SerialNumbers
Weight
Pallet
Destination/Location
and I would guess these are related to Customers and Orders (guess only)

I think there is more to your post that has been discussed.

[krai]

No customers or orders. I have Pallet Number, Supporting (location), Contains (item type, item name) Serial number and Weight

I want it to do different things.
The thing with the pallets create new from supporting, witch is my problem.
List all items where it is packed.
List all items on one pallet. Print out a sheet that I can put on the pallet for packing, so its easy to see where it goes.

[orange]

OK. So all of the info you need is stored somewhere.
Based on your responses/posts, I see the following "rules":

A Pallet contains 1 or more Items
An Item has Weight
An Item has a SerialNumber
Each Item belongs to an ItemType
A Pallet has 1 and only 1 SupportingLocation
An ItemType contains 1 or more Items

Does this make sense?

[krai]

It makes sense yes.
I just don't see how I fix my problem. the auto numbering

[orange]

Please show us a screen capture of your tables and relationships.

Generating a number doesn't seem to be the biggest issue (to me anyway).
This is a database forum, so please tell us about your database.

Your database should support the rules identified in previous post.

[krai]

here you see my db so far.

[orange]

I see a new "entity" -- palletGroup? What is this exactly?

I'm going to suggest you work through this tutorial that will demonstrate how to breakdown your business description into appropriate tables and relationships. This will get you a database and table structure to support your business. The process and steps you learn can be used with any database.
The tutorial includes a solution. You have to work through it to benefit. (takes about 30-60 minutes)

See this link if you need more info on Normalization.

Here is a draft data model I created based on our posts.
Good luck.

[krai]

Build a new database from your picture and now I build a form and I now get a type mismatch when I try to go to form view from design view.

[orange]

??Did you work through the tutorial I suggested?

My picture was a draft design for consideration. It has not been tested with any of your data. It certainly is not yet suitable as the basis of your database.

Do the tutorial, then post back.

[krai]

Still didn't get how I auto sequence a new pallet number from a pallet group.

[orange]

What is a PalletGroup?
How do you assign PalletNumbers now?
Did you do the tutorial?

Can you show readers your "description of the business" as per the tutorial?
Also can you show us the data model(ERD) you built based on the tutorial?

Info re Autonumbers.