Conditional Value Lists in an existing database
I've created a sign-in database where volunteer members (firefighters) sign in and sign out each time they come into headquarters.
On signing out, they need to enter the activities they completed. There will be three levels - ie they choose a general category, then a second category and then a third category, with options conditional based on the level selected above.
I've completed the knowledgebase tutorial for conditional value lists and it was easy - but how do I add this into an existing layout. I have multiple tables already related by the user ID number, so I tried to create another table of activities and don't know how to relate this to the "log" table, which has most of the data.
Any help or pointers would be greatly appreciated! Thanks