rekoal Posted February 8, 2007 Posted February 8, 2007 hey guys/ladies, I am currently doing an A-level in ICT and we've just started access. i have a big idea and have already started it but i am stuck and dont know how to continue it, so i am wondering if anyone can help me out? Basicalyy i have chosen to replica a Motorbike shop with a parts deparment, in this parts deparment we have 4 suppliers, Honda, Yamaha, Suzuki, Kawasaki. I am trying to create an orders form, which you can select the supplier which will bring up different part serials. The relationships view helps demostrate what im trying to achieve: What im stuck on is this: this is what i want to happen, i want a drop down box, with all the suppliers in and then that to cause in the Parts serial to display all of the Serials. i have 4 Serials in a table for it to be looked up in, displayed here: this is the same for each different supplier. Then a save button, so later on i can create a form to say completed, in progress. if you need me to explain any further please just say many thanks rekoal
TucksonSonny Posted February 8, 2007 Posted February 8, 2007 Check out the “Northwind.mdb” example! ;) If I remember it correctly it is about customers, products and suppliers… DELL Intel® Core™ i7 Processor 940 2,93 GHz @3 GHz, 8 MB cache | 8.192 MB 1.067 MHz Tri Channel DDR3 | 512 MB ATI® Radeon™ 4850 | 500 GB 7200 rpm Serial ATA | Samsung SM 2693 HM 25.5 " | HOTAS Cougar Thrustmaster |
Kula66 Posted February 8, 2007 Posted February 8, 2007 This is about as OT as you can get, but ... Ok, this is from long ago, but set the Row Type to Table/Query and in the row source put in the SQL statement that will get the values e.g. SELECT DISTINCTROW [vAllPersonDetails].[PersonName], [vAllPersonDetails].[PersonID] FROM [vAllPersonDetails]; I think the wizard will take you through it ..
Recommended Posts