Job number

[deepcec9]

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

 

[arnelgp]

then you have to modify the above table, create a new field jobID as long integer. create another table Jobs with field JobID (autonumber), JobNumber as shortext, Description as shorttext.
fill your Jobs with JobNumber, update your in/out table's JobNumber with the JobID from Jobs table.
after all is update is done, create a relationship between Jobs and your in/out table joining Jobs' JobID field to your in/out JobID field, create an left outer join (include all records in Jobs table).

 

[deepcec9]

then you have to modify the above table, create a new field jobID as long integer. create another table Jobs with field JobID (autonumber), JobNumber as shortext, Description as shorttext.
fill your Jobs with JobNumber, update your in/out table's JobNumber with the JobID from Jobs table.
after all is update is done, create a relationship between Jobs and your in/out table joining Jobs' JobID field to your in/out JobID field, create an left outer join (include all records in Jobs table).

I want to create a sequential number for jobs "WI"&&&, it increments.
How to update this in each record?

 

[GinaWhipp]

Have a look here...
http://regina-whipp.com/blog/?p=704