Joel Saltzman Posted November 20, 2006 Share Posted November 20, 2006 I have a Point of Sale system that I am trying to modify that I made. There are 3 tables Order LineItems Inventory The LineItems is a portal on the POS form. Each product has a custom barcode printed for it. The barcode simply is the product's SKU number. When the SKU is scanned into the SKU field of the portal, it retrieves the ItemName and Price from the INVENTORY table. Is there some way to make it so that the clerk can scan either the custom barcode on the package OR the UPC barcode on the package? All UPCs can be used as primary keys in the system. I want to be able to scan either one into ONE field and not worry. UPCs and SKUs do not EVER have a possibilty of being the same... I was thinking of something with a sku_upc field and self referencing relationship but dont know how i could do that.... ANY IDEAS?? Link to comment Share on other sites More sharing options...
mr_vodka Posted November 20, 2006 Share Posted November 20, 2006 Try creating a new table called 'barcodes' and have it be a one to many from Inventory to Barcodes. Then in your line items table, you can reference the Barcodes table instead of directly to the Invetory table. Link to comment Share on other sites More sharing options...
Joel Saltzman Posted November 20, 2006 Author Share Posted November 20, 2006 Im not sure if I understand your idea right.... So, I would have a table with UPCs and SKUs that is linked to the inventory table and have redundant info from the duplicate SKUs? Link to comment Share on other sites More sharing options...
comment Posted November 20, 2006 Share Posted November 20, 2006 Assuming each item in Inventory has both a unique SKU number and a unique UPC number, you could define a calculation field (in Inventory) = SKU & ¶ & UPC and change your lookup relationship to match this field. Link to comment Share on other sites More sharing options...
Joel Saltzman Posted November 21, 2006 Author Share Posted November 21, 2006 Ah! that sounds like what I wanted to do. What would the relationship look like though. I am having a brain fart on this one for some reason.... Link to comment Share on other sites More sharing options...
comment Posted November 21, 2006 Share Posted November 21, 2006 The same as now, except for the change of match field in Inventory, i.e. LineItems::ScannedProductID = Inventory::cCombinedProductID Link to comment Share on other sites More sharing options...
Joel Saltzman Posted November 21, 2006 Author Share Posted November 21, 2006 COOL! Thanks!!!! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6364 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 accountSign in
Already have an account? Sign in here.
Sign In Now