I have a table ActionItems that contains hundreds of records of actions that are specific to a certain customer and a related value list that shows the actions for the client whose record we are in at the time. The table contains three columns only; ClientID, ActionItemID and ActionItem.
What I would like to be able to do is have a series of global actions that are available for every client and have those appear in the same value list.
is this possible and if so, how do you do it?
TIA[/b]