Value Lists

[DAVEKK]

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?

Please Advise

Thanks

David Kennedy

[bcooney]

In the interest of clarity, you do not have two DB's. You have two tables in the same FM file. DB (database) is not really a FileMaker term. You could refer to the entire solution (multiple files, perhaps, each with multiple tables, as a "Database.") I don't mean to be a nudge, it's just that using proper terms will help you in the long run.

And so, you've related Budgets to Payee by PayeeID. Your screen shot doesn't show us the relationship in full. Perhaps you have a "create records" checked?

All you need is a value list (the definition of yours is a mystery as well), that consists of two fields, PayeeID and FullName. Then assign that value list to the Budget Payee foreign key. Format it to be a popup menu.

However, you could simply create a new Budget record from the Payee form, and populate the foreign key with a script:

New Budget Form btn (script)

Set $payeeID to Payee::PayeeID

Go to Layout (Budget Form)

New Record

Set foreign Payee ID to $payeeID

hth,

Barbara