Good Day,
I am doing a simple file management database, BUT my friend wants different fields filled in based on the category of file (Where category is not the same as a file type such as ppt) such as journal article or a book or a case or a presentation
1. user browses the file system and adds a file hyperlink
2. they use the "category" field and set it to = journal article or a book or....
3. based on the category field I need data filled in - some is the same for all of them but mostly it is different, For each category I have a different file,
The options I have come up with are
4.1 a sub form to appear for each category type
OR
4.2 a sub form which shows all the fields for all the categories, but stops entry into fields that are not valid for the category
OR
4.3 I had normalized all the data BUT the user wants to search all the fields so I am not sure whether I should just reuse the fields for differnet purposes to cut down the number of fields he has to search for
regards Renovator