Displaying field contents based on category
Posted on 2000-01-06
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.