Design Questions
- From: down in flames <downinflames@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 25 Nov 2008 07:12:10 -0800
I am starting what at first looked like a fairly simple project but I am
hitting some walls that I need some help with. What I am trying to do is
take several excel part number (by vehicle) listings and combining them into
one application in Access. The end users would enter vehicle make, model and
year via drop down boxes then would be shown which part numbers (across
several product lines) fit that specific vehicle.
I have started small by creating 3 tables:
tblVehicleInfo: Contains make, model, year info
tblHarness: Listing of part numbers for wiring kits
tblKits: Listing of part numbers for installation kits
I have entered data into all of the tables and they all use an autonumber
primary key. I am not sure if this is the best way to do it but it seemed to
make sense. The next step is where I have a few questions:
1) tblHarness and tblKits are product lines, how do I associate the part
numbers in these tables to specific vehicles? Almost every part number in
these tables would be listed for more than one vehicle.
2) When creating the drop down form to test the interface, how can I make it
"cascade" to only show entries applicable to the previous drop down. ie If
you select BMW in the "make" drop down box, only BMW models show up in the
"model" drop down box?
I have been using Excel for these types of projects for many years but I
think Access will provide a more space friendly approach if I can get a
handle on these types of basics. Any help would be appreciated.
.
- Follow-Ups:
- RE: Design Questions
- From: Clifford Bass
- Re: Design Questions
- From: Dirk Goldgar
- RE: Design Questions
- Prev by Date: Re: Show only blank check boxes in a query
- Next by Date: Re: MaxDate problem
- Previous by thread: Show only blank check boxes in a query
- Next by thread: Re: Design Questions
- Index(es):
Relevant Pages
|
