Look up a value

B

Bonnie

Hi Ya'll,

I am producing requisitions on a form - I would like to fill the requisition
number by take a department code - looking up the department code in the
NEXTNO table which has a field with the department code and a field with the
nextno.

Here's the table:

NEXTREQ
DeptCode
NextNo

Something like:

ReqNo = NextNo FOR LEFT NextReq.DeptCode=(ReqNo,2)

Then I need to add 1 to the nextno value of this same record.

Can anyone help me please.
 
Top