Using Microsoft Access as a cross referencing tool

Question

I am trying to create a tool that can be used to cross reference manufacturer part numbers and descriptions to my part numbers.  Can this be done with Access?

Answer 1

You aren't giving us a lot of info to go on here. I'm guessing you have a table of your part numbers. And you periodically get a spreadsheet from your suppliers with their numbers. You can link to or import the workbook(s) Youll have queries that link the three tables together. Other queries that will show new parts on either side so you can create the cross reference records,

Answer 2

Great info Scott! So once i create the cross reference table how would i go about importing the information i need crossed to the part numbers/descriptions on the table? The information usually is on an excel spreadsheet.

Answer 3

Thanks for the info Karl!

Answer 4

Yes, it can be done. Essentially I would create a cross reference table:

tblPartXref

PartXrefID (PK Autonumber)

MyPartID (FK)

MfgPartID (FK)

Answer 5

Yes, using one table if there is a one-to-one relationship from manufacture to your number.

If this is all that you will be needing it for then an Excel spreadsheet will work  by sorting on the column containing the type of number you have in order to find the other.