External Cross Reference Database

  • Thread starter Thread starter norgren123
  • Start date Start date
N

norgren123

I am working on building a database to cross reference part number
the their respective design prints. The goal of this is to creat
something easy for people to use so that all they have to do is ente
the part number and then have the corresponding design print open u
for them on the computer.

I was thinking of creating a database in Access then using PHP an
mySQL to query the information in the database and cross referenc
the part numbers to their design prints.

I was wondering if there were any other methods I could use to ge
similar results
 
I'm having trouble with what "PHP" is supposed to represent, but, I had a
similar project several years ago. Unfortunately, I didn't keep a copy, but
the process, as I remember it, was

I created the database table with the part number and "path" fields. The
"path" was the a "fully qualified" path to the relevant part's drawing.

I created a form consisting of a single ComboBox linked to the part
number. The after update event used th SHELL() command to open CADD.exe and
passed in the path.

This allowed the user to edit the design (my routine was for the design
engineers, you may not want to allow this in your app).

When the user finished he either closed CADD , or he could minimize the
current drawing, and he was returned to the Access form so he could select
another part.

HTH..

BAC
 
Back
Top