|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.