P
plisvb via AccessMonster.com
Hello,
I've created an inventory dbase for a grocery warehouse and initially I
created one table for different types of invoices:
1) Incoming
2) Outgoing
3) Shrinkage
My accountant has informed me that each invoice of each type must be
sequential so incoming are INC1,INC2,INC3 and outgoing are O1, O2, O3 instead
of the numbers being mixed.
If I would've know this at the beginning I would've separated the tables, one
for incoming, one for outgoing etc...
Is there a way to add another autonumber field and have it only increment
depending on the type of invoice it is?
I've tried adding creating another table just to hold the Incoming number
ID's and linking it to my main table but when I add it to the form that I'm
using, all the fields go blank.
Thanks
I've created an inventory dbase for a grocery warehouse and initially I
created one table for different types of invoices:
1) Incoming
2) Outgoing
3) Shrinkage
My accountant has informed me that each invoice of each type must be
sequential so incoming are INC1,INC2,INC3 and outgoing are O1, O2, O3 instead
of the numbers being mixed.
If I would've know this at the beginning I would've separated the tables, one
for incoming, one for outgoing etc...
Is there a way to add another autonumber field and have it only increment
depending on the type of invoice it is?
I've tried adding creating another table just to hold the Incoming number
ID's and linking it to my main table but when I add it to the form that I'm
using, all the fields go blank.
Thanks