Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 26th, 2003, 04:46 AM
Authorized User
 
Join Date: Jun 2003
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hmz...a tricky problem (at least for me )

your problem is that u don't know how many fields u should declare in your access database, right? if u declare 5 fields in your database and a user creates 10 fields the problem is: where am i gonna save those 5 extra fields...

i really haven't got a clue how to do that with access

just out of curiousity: what kind of system are u making?
 
Old June 26th, 2003, 08:45 AM
Authorized User
 
Join Date: Jun 2003
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

you mind if i email you private?
 
Old June 26th, 2003, 09:30 AM
Authorized User
 
Join Date: Jun 2003
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i'm working on a system that (if it will run, ever) will run on an intranet. it is suppose to track and report on the performance of employees in terms of how they handle different assets as well as receipt and invoices.
e.g (i like examples)
a Case (meaning property and assets to manage) consists of 5 assets various or similar in nature:
there is a questionaire for each asset type like: has the asset (unique Number) has been properly stored? has it been recorded? has the asset been maintained? are the expenses for storing and mainaining been recorded in a given timeframe ... etc.....
the system is suppose to log who was the employee handeling the case, what team, what division ?

Here is the problem:
depending on the case there might be 3 assets... or 30 assets... they might be all different in nature... or some might be similar (like 5 assets 2 of which are real estate, one is a car(movable) 2 are cash assets


the way i approach it is:
3 tables in access
one containing the questionaire with all criteria the key is the CriteriaName like Cash & #, CR#, Move#
the next table will hold the ReferenceNr. as key the EmployeesName, division, assetNr.
the 3rd table holds the refNr. AssetNr. CriteriaName and the status (if criteria is met or not or n/a)

i am thinking of creating an entry in the 3rd table for each asset (and assign it a new id as a key).. my problem is to have the update(or create new record) page figure out the values of the assets if teh total nr. of assets varies?
(keep in mind that even the criteria might be added to or deleted in time they might not want to check on all 50 criteria anymore, or they need to create new criteria if other problems start to show)

It's more trickey than i thought...phhhhewwwww
 
Old June 27th, 2003, 12:50 PM
Authorized User
 
Join Date: Jun 2003
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

still struggeling with it ... has anyone an idea??
 
Old June 28th, 2003, 05:44 AM
Authorized User
 
Join Date: Jun 2003
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

u can mail me private if u want...don't know if it will help much





Similar Threads
Thread Thread Starter Forum Replies Last Post
Access input controls generated by Client Script vinod_yadav1919 ASP.NET 2.0 Professional 3 April 14th, 2008 08:33 PM
saving tables that are generated by queries as HTM miamikk SQL Language 0 October 17th, 2006 04:17 PM
Export from Access to Excel in ASP generated page u0107 Classic ASP Basics 1 July 16th, 2006 05:25 AM
HTML content in Outlook Emails generated by Access Justine Access VBA 0 January 13th, 2004 04:47 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.