I have two DB's related via P & F key Id fields.
Within the Budget DB I have a pull down field defined to use the Payee::Payee field data to populate the field in the pull down within the Budget DB.
This appears to function fine except whenever I add a new record with in the Budget DB selecting one of the data values from the related Payee DB it also adds a new record to the Payee DB?
I am attempting to use the data values from the Payee DB and be able to add new records in the Budget DB either using an existing Payee::Payee data value or adding a new one from within the Budget DB..
I am not sure what I am doing wrong with this?