Inside a PM app I have an Issues table and a Contacts (resources) table with the contacts < issues relationship.
When an issue is raised there is a "raised by" field and an "owner" field, both of these fields are currently set as Text - Multiple Choice with the choice "from another field" pointing at the Contacts table, this works as a picker but doesn't allow entry of new contacts as you would get with a relationship drop down.
NB: I realise the "raised by" field duplicates the "record owner" field, but not everyone who needs to have their name in "raised by" will be a user of the QB app
Is there a way to use the "contacts - name" field twice in the same form? Just to avoid frustration from the people completing the form that they have to drop out of the issue and move to another table to create a new contact.
Thanks Phillip! I genuinely hadn't thought of just creating another relationship, much appreciated!
The contacts table is going to end up riddled with relationships since I have the same situation in a risk, change and decision log as well.