Hi all,We have a marketing calendar table which links a CAMPAIGN to individual DISCOUNT records in another table. Each CAMPAIGN has 4 or 5 DISCOUNTS in successive panels, and so we have 5 linked records from each CAMPAIGN to the DISCOUNT table, label...
Thanks Adam,This looks perfect! I'm gonna try to duplicate what you did on my own for the learning process, but just in case I need to cheat — I didn't see a link to the base in your message. Did I miss it?Thanks again for the help, this is awesome. ...
Here's our "Marketing Calendar" table (or one view of it anyways)Each "Panel" field (Panel 1, Panel 2, Panel 3 etc) is a linked record in the "Codes" table here: I want the records in the codes table to display the date corresponding to any of the "P...
