Thanks for your reply. Well, the thing I guess I need to consider is that the three attributes that are populated automatically can change over time - can be renamed and the statistical characteristics altered as policies change, so actually the best thing I can probably do is update the Tables as necessary when these changes occur and then run the reports and save them as we need them and just have explanatory notes to back up the reports.
...

Good afternoon!

So - the database I am currently working on has 2 FORMS; one for adding new clients, one for editing existing ones. I need 4 levels of user access for the DB:

AUTHORISED USER: Will be able to run queries and reports, but not access the Forms or the Tables.

APPROVED USER: Will be able to do as an AUTHORISED USER but also use the EDIT PARTICIPANT form to change data.

SUPER...

Good morning!
I am currently working on a database (Access 2016) and have a situation that I am stuck on. I have a form that I am using to collect data for people that we are linking to an education scheme. This consists of mostly generic information that needs to be entered, but there are some fields I have set up to be automatically populated based on other data we hold as an organisation (this is to help with reporting).

...