I think this should be pretty simple, but im pretty dumb so hopefully someone here knows more about this than i do

All i want to do is have a simple database where a user first selects a customer from a drop down list. that then gives them a list of part numbers for that customer. Then when they select a part number it returns a document ive created (preferably in .pdf but could use an excel file , word doc, etc.)


is Access best for this ? Excel ? Something else ?

Boilermaker Rick says he will do this for you free of charge with a propriety utility built from C if you join our Clash of Clans.

_________________
Rick Hahn is the best GM in baseball.

I used Access for this in school many moons ago. It is easy and the table portions are essentially Excel so if you can do that you can do the Access. That is if MS still call Access Access?

_________________

I assume you want this online, accessible via the web (desktop/tablet/handheld device).

No need to pay for MS products for this. In fact, MS products for the most part aren't the right solution for
online solutions.

WordPress (php/mysql as the database layer) with, say, the Ninja forms plugin.

It's all free-as-in-beer and free-as-in-speech open source. Easy to work with and easy to find people to help out
at affordable rates.

You'll likely wanna have 3 tables.

CUSTOMER
=======
CustomerID
[customer info fields]

PART
=======
PartID
[part info fields, including either a link to the pdf doc or the actual pdf doc in BLOB (Binary Large OBject) format]


CUSTOMERPART
=========
CustomerID
PartID


^^^assuming that multiple customers can be connected to any individual part.

Other tables as well, potentially,depending on what else you want to do.

PHP/Mysql (what WordPress runs on) hosting is mad cheap, like $5 a month or under $50 a year when paid up front.

How much actual programming do you want to do? There isn't a good out of the box solution for this that doesn't require a little bit of programming.

I've never worked with Access though.

_________________
You do not talk to me like that! I work too hard to deal with this stuff! I work too hard! I'm an important member of the CSFMB! I drive a Dodge Stratus!

I'd tell him to go on freelancer.com or fiverr.com and have someone do it for cheap.

_________________
You do not talk to me like that! I work too hard to deal with this stuff! I work too hard! I'm an important member of the CSFMB! I drive a Dodge Stratus!

Douchebag Enterprises has already been contracted for this work.

_________________