Displaying field contents based on category


I am designing a database which contains documents that have multiple categories. I have created a view that displays the same document under different categories. I would like to know how I can display different information in another column based on the category that the document is currently being displayed under? In case this is not possible, I will explain why I am doing this so that you can maybe point out an alternative. I am designing a purchase order database and I would like a given purchase order to fall partially under two different categories by percentage so, say 60% under hardware, and 40% under software. I have a view that displays totals for each category, so I need to be able to display the correct cost under each category so that the totals for each category are correct. Thanks for your help.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Unfortunately it isn't possible to show different values as you require. The only way I can think of doing it is to split the one form into 2 different forms (or however many catagories you have) using script in the Queryclose event, this would make displaying the view trivial. The problem is how to manage the seperate documents. I have done something like this for holiday requests (I won't go into why!), but when you go into the split forms, it takes you back to the original form (by way of doclinks)and this is all invisible to the user.
To be honest though, I don't think Notes lends itself to the sort of application you are writing.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.