| Chicago Fanatics Message Board https://mail.chicagofanatics.com/ |
|
| database advice/help needed https://mail.chicagofanatics.com/viewtopic.php?f=39&t=92709 |
Page 1 of 1 |
| Author: | Bagels [ Tue Mar 10, 2015 8:59 am ] |
| Post subject: | database advice/help needed |
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 ? |
|
| Author: | IMU [ Tue Mar 10, 2015 9:10 am ] |
| Post subject: | Re: database advice/help needed |
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. |
|
| Author: | pittmike [ Tue Mar 10, 2015 9:50 am ] |
| Post subject: | Re: database advice/help needed |
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? |
|
| Author: | Hussra [ Tue Mar 10, 2015 10:03 am ] |
| Post subject: | Re: database advice/help needed |
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. |
|
| Author: | Brick [ Tue Mar 10, 2015 10:17 am ] |
| Post subject: | Re: database advice/help needed |
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. |
|
| Author: | Brick [ Tue Mar 10, 2015 10:19 am ] |
| Post subject: | Re: database advice/help needed |
IMU wrote: 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. I'd tell him to go on freelancer.com or fiverr.com and have someone do it for cheap.
|
|
| Author: | Douchebag [ Tue Mar 10, 2015 10:20 am ] |
| Post subject: | Re: database advice/help needed |
Boilermaker Rick wrote: IMU wrote: 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. I'd tell him to go on freelancer.com or fiverr.com and have someone do it for cheap.Douchebag Enterprises has already been contracted for this work. |
|
| Author: | Bagels [ Tue Mar 10, 2015 10:26 am ] |
| Post subject: | Re: database advice/help needed |
Douchebag wrote: Boilermaker Rick wrote: IMU wrote: 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. I'd tell him to go on freelancer.com or fiverr.com and have someone do it for cheap.Douchebag Enterprises has already been contracted for this work. 
|
|
| Page 1 of 1 | All times are UTC - 6 hours [ DST ] |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|