Duplicate entry for invoices entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a simple invoice entry form. And I need help creating
a code that would prevent a user from entering a duplicate number for each
vendor entered.
I noticed that If I prevented duplicates numbers at the table level it would
work, however it would prevent duplicate numbers for all vendors.....which
would not work. I have only four fields, me.vendorname, me.vendorno,
me.invdate, me.invamount; the table is called "entry". Any help is
appreciated, thanks.
 
I am trying to create a simple invoice entry form. And I need help creating
a code that would prevent a user from entering a duplicate number for each
vendor entered.
I noticed that If I prevented duplicates numbers at the table level it would
work, however it would prevent duplicate numbers for all vendors.....which
would not work. I have only four fields, me.vendorname, me.vendorno,
me.invdate, me.invamount; the table is called "entry". Any help is
appreciated, thanks.
Click to expand...

Create an index on the table that includes both the Vendor and Invoice.
To do this isn't totally intuitive; you need to add another field to the
index on the next line. Make that index unique, and you're all set.
 
Armen, am I understanding you correctly...enter both the vendor name and
invoice number in the same field? How do you go about enntering the
information on the form?
 
Armen....you are awsom, I just figured it out....you go to view then indexes
in order to create the connection.
 
Back
Top