Jump to content

Unique IDs with matching prefixes


adrsub

This topic is 2499 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

We use our database to track purchase orders that come into our office and are then sent to vendors. The "Product Catalog" table uses a UPC as the primary key which is linked to the "Purchase Order" table. Users create a PO and enter the UPC which then populates item description, price, etc. They then enter how much of each item is ordered. Majority of our products have unique UPCs which work perfectly as the field is set to require a unique value. However, there are a few instances where we sell a branded item to multiple customers, meaning I need to somehow differentiate the UPC between each customer. My solution for this was simply to add three letters to the end of the UPC to identify which customer this product needs to be linked to. Unfortunately when I try to achieve this I'm told that the field needs to be unique. If I turn off the "require unique value" setting, the sales between all customers reflect on any customer that sells this product. Any ideas on how to resolve this?

Link to comment
Share on other sites

1 hour ago, adrsub said:

My solution for this was simply to add three letters to the end of the UPC to identify which customer this product needs to be linked to. Unfortunately when I try to achieve this I'm told that the field needs to be unique.

Is it possible that the field is defined as a Number field?

Link to comment
Share on other sites

This topic is 2499 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.