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?

you mind if i email you private?

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

still struggeling with it ... has anyone an idea??

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