Incremental numeric fields

[Miltomatic]

Hello everyone

I am a complete novice trying to design a database to control the distribution on stock between 7 locations.

One field in the database, which is there for my benefit, is a sequential number which increases by one with each new record.

Each location also needs their individual stock allocation to be numbered sequentially. How do I design a second field, which will take the last number used for any location and add 1.

Any help, advice or a pointer to a specific url or tutorial would be gratefully received.

Thanks in advance.

Milt

[IdealData]

Did you look at the help system yet?

Also there are some sample files with your FM installation - look at those for some ideas.

[comment]

Create another table for locations, with a similar auto-entered serial number. To assign a stock item to a location, pick the LocationID from a value list. Relate the two tables by matching the common LocationID value.

[Miltomatic]

Thanks very much for that - a lot of what you say has gone over my head, but, now that I have a goal, I can read, research and learn.

Many thanks

Milt

[comment]

That's the right spirit.

Here's a simple file that shows what I meant.

Locations.fp7.zip