S
SG
Hello,
I developed an access front for user to be able to enter data into MS SQL
table.
I have an order table called tblOrder:
order# (primary key)
date
I have a detail table called tblData is:
order# (Primary key)
itembarcode (Primary key)
I developed a data entry form called "Enterfrm", when user enter the order#
and barcode on the subform, if the barcode is duplicate, the system will
complain.
Recently I was told that the itembarcode on one order could be duplicate,
because the barcode of some item is same which is only 12 characters. They
need to enter all the itembarcode for tracking quantity even it's duplicate.
But some of item are still unique (16 characters)which need to be avoid from
entering twice.
What I like to do is that when the user is entering the data, access will
validate the lenghth of the barcode, and in some way to accept both
duplicate item and non-duplicate item.
I've been thinking a way to do so, don't know how to achieve this. Would two
detail tables do it?
If two tables, how do I design a form to enter the data into the proper
table.
Hope I explain my problem clearly,
Please help,
Thanks so much,
Sarah
I developed an access front for user to be able to enter data into MS SQL
table.
I have an order table called tblOrder:
order# (primary key)
date
I have a detail table called tblData is:
order# (Primary key)
itembarcode (Primary key)
I developed a data entry form called "Enterfrm", when user enter the order#
and barcode on the subform, if the barcode is duplicate, the system will
complain.
Recently I was told that the itembarcode on one order could be duplicate,
because the barcode of some item is same which is only 12 characters. They
need to enter all the itembarcode for tracking quantity even it's duplicate.
But some of item are still unique (16 characters)which need to be avoid from
entering twice.
What I like to do is that when the user is entering the data, access will
validate the lenghth of the barcode, and in some way to accept both
duplicate item and non-duplicate item.
I've been thinking a way to do so, don't know how to achieve this. Would two
detail tables do it?
If two tables, how do I design a form to enter the data into the proper
table.
Hope I explain my problem clearly,
Please help,
Thanks so much,
Sarah