Thanks to everyone for their spot-on suggestions about magical merge fields! I have another question that vexes me.
I’m designing a database for work. We need to be able to enter any number of objectives into the database and mark them as active or not on an individual basis. This part is easy. What I’m having trouble wrapping my head around is that later on I need to give people the option to select from a drop-down list of only those objectives that are marked as active. I initially had created a value list from the objectives table, but that won’t exclude objectives where flag_active is 0 (inactive). I suppose I could build another table of objectives that only includes those from the original that are marked as active, but wouldn’t it need to be rebuilt from scratch every time an objective was added or its status was changed? I don’t want to delete objectives, just mark them as inactive, because they might be needed again in future. Thank you all for your sage advice! -- David O’Donnell ? [EMAIL PROTECTED] Director of I.T. ? ☎ +1 703/421-2610
