I have a column that I need to place on lists in multiple sub-sites for users to enter the account number for the activity of a project. This will be a "choice" column with three options:
- The default account number for the project
- An option "No project funds required for this activity"
- A "Specify your own value field"
The only difference across the sub-sites is the default account number since it's specific to each project. I'd like to use a site column for this but I need to populate the account number option automatically/programmatically so that it recuperates the account number by a lookup on the project code or similar. If I enter the account number manually after inserting the site column on the list I find that any updates done to the site column for which I choose to also update the list columns will also change the list of available values.
Any ideas or advice on how I can do this?
Many thanks Chris