Where a table has two multi-ref fields, it would be nice if one could be made the default value for the other.
For example, I have the tables Contacts and Roles. Joe Bloggs is a Contact. ABC Company is a Contact. Joe Bloggs as director of ABC Company is a role.
In the Contacts table I have a multi-ref to the table Categories which might say that Joe Bloggs is Contractor and a Suplier. When I set up the role, I want to be able to give him different Categories, but by default I want to show the categories already entered at Contact level and then overwrite these.
