job number

[deepucec9]

Hi,
I am creating a warehouse inventory and I want to update each job with a unique job number.
For example: Each job has different line of products coming IN/OUT.
product1 ... 50 quantity ... suppliername
product2 ... 25 quantity ... suppliername and so on
So when I search using job number it gives all products and its details.


I am a newbie please help

[Homegrownandy]

auto number field will auto generate unique numbers for your record. This makes it a great choice for being a primary key.

[Homegrownandy]

post a sample database for people to review if you like. I'm sure there's a lot of suggestions people could make.

[deepucec9]

post a sample database for people to review if you like. I'm sure there's a lot of suggestions people could make.

Thank you for the reply,

I wan to create create a sequential number which I manged by using "WI"&&& in format.
In one job there are 2 or more products, so how to link this job number to products.
Scenarion: 2 products coming to warehouse product1 and product2. Both has same job number.
And when I do the next job "job number" increment

[Homegrownandy]

your jobs table contains only information that is specific to that job and not repeated.

you need another table that links to your job through your primary key. (as I said earlier.. auto number is your best bet)

then on this new table you have new records that reference the job.

something like this,
Product_ID - job_ID - Details - Qty

1-1-product 1-10
2-1-product 2- 10

this shows 2 products coming in for 1 job.

[deepucec9]

Created the same, table: Jod
job_id (autonumber) suppliernmae(text)

table product
productid (autonumber) jobnumber (number) quantity (number)

How to link job_id from table job to jobnumber fieild of table product

[Homegrownandy]

name the field Job_ID in both tables. < you don't need to do this but I find its easier later on if you do.

click database tools at the very top. then click relationships.

put your tables on here and manage them.. drag job_ID to job_ID. make sure the 1 to many is set up right.

you should spend a few hours watching a youtube series about the basics of access. It will help a lot!