This content has been marked as final. Show 1 reply
Sounds like you have the following:
- If you double click the relationship line shown above, I suspect you'll see "Allow creation of records via this relationship" enabled for the Payee table.
- If you enter layout mode and check your Payee table, I think you'll find it comes from Payee instead of Budget.
- Thus, when you enter data in the Payee::Payee field, the relationship automatically creates a new related Payee record.
Here's what you should have:
- The "allow create" option in the above relationship should probably be cleared. I could be wrong, but I can't imagine a use for this option here. (Depending on your layout design, you may want to select this option for Budget if you have a portal on a Payee layout for entering new budget data.)
- The Payee field in the Budget table should be deleted. This field is redundant. You can use the relationship to Payee and display Payee::Payee whenever you need to display the payee name.
- _kp_PayeeId should be an auto-entered serial number.
_kf_PayeeID should be a simple number field (No auto-entered serial number).
- So you can link a given budget record to a selected payee, put Budget::_kf_PayeeID on your layout and format it with a 2 column value list where column 1 is Payee::_kp_PayeeID and Payee::Payee is shown in column 2. You can either use a drop down list for this or, if you use validation to enforce unique names in Payee::Payee, you can use a pop up menu and specify that the value list hide the first column. With a drop down list, you'll then add the Payee::Payee field to your layout next to _kf_PayeeID so that the payee name will be visible after you exit the ID field. (A Popup menu, when used as I've described, enters the ID number but displays the matching name so you don't need the extra field in this case.)