Show Bid Request ASP Data Shaping Project Bid Request Id: 7962 Bookmark in my 'To Do' list Posted by: Pogeystick Joe (3 ratings) (Software buyer rating 10) Non-action Ratio: Above Average - 25.00% Buyer Security Verifications: Unverified Approved on: Jan 24, 2002 12:37:21 AM EDT Bidding Closes: Feb 7, 2002 12:38:53 AM EDT Viewed (by coders): 773 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: ASP Enter chat room for this bid request (0 active users at Sep 25, 2003 8:37:21 AM EDT) Description: I have an Access 2000 database with 4000 records that I would like to display results in a hierarchical order with grandparent showing records and hyperlinked parent items, then parent items showing hyperlinked child items. The database will come with the project so that you can see the datamodel. Deliverables: Two asp pages; One that submits the first grandparent item to the second. This page will be supplied. After the querystring is determined this will display the first grandparent recordset in a single column, multi-row result (State Information); Below this result, will be displayed a hyperlinked 5 column table that will display all available parent records within the grandparent (Counties); When a user selects the parent (county) that they want it will display the resulting recordset in a single column, multi-row result (County Information); Below this result, will be displayed a hyperlinked 5 column table that will display all available child records within the grandparent/parent relationship (City Information); When the user clicks one of these hyperlinks it will display the child record in a multi-row single column result. The final result will be that the user will see all Grandparent/Parent/Child (State/County/City)Result sets on one page. UPDATE: Sorry, forgot this. It must have a hyperlinked text trail at the top so that the user can navigate back up and down their path. State --> County --> City. END UPDATE Database model is included below along with the first page, then a sample of what I want the second pages final result to display like. Complete and fully-functional working program(s) in asp format form as well as complete source code of all work done. Complete copyrights to all work purchased. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! Jeffery Crooks (13 ratings) in Virginia Beach, Virginia United States Bid id: 92,005   $10 (USD) Jan 24, 2002 10:29:50 PM EDT  9.76 (Excellent)     As a new user, I'm looking for an opportunity to get some sort of 'track record' started here at RentACoder. Would enjoy the change to help you out with this project. Would just need your DB as well as any GUI design requirements you may have (color scheme, layout, graphics, etc.) My understanding from your requirements, this is 'view' only, not editable information. Jeffery           There are 5 private replies to/from Jeffery Crooks. Click here to view them.