Auto reducing drag and drop portal

[pinotblogger]

Hi everyone.

First off, just a quick note to say that what I've been able to develop with FileMaker 10 in just the first month of using it has been phenomenal. As a winemaker, I've been able to recreate and improve upon solutions that in my industry cost tens of thousands of dollars. And I've enjoyed almost every minute of the process.

My current issue has to do with my implementation of an FM 10 specific drag and drop technique developed by Andrew Persons at Excelisis ( http://www.excelisys.com/web/downloads/index.php).

In standard wine production after crush/destemming, grapes are loaded into fermenters of various sizes (usually 1- 6 tons for small wineries).

In my database, named Juice, this simply means that I must assign a Lot of grapes to a particular Fermenter by populating a foreign key in the "Grape Lots" table with a fermenter's primary key.

I could do this with a Layout based on a Table Occurrence of "Grape Lots" and use a drop down list, but I don't think this is an intuitive or elegant approach.

Instead it makes more sense to me to build a layout based on a TO of "Fermenters" and select from a list of available Grape Lots and assign them to the fermenter there. When I saw the drag and drop technique, which is highly intuitive, I adapted it to my situation.

In my file. on the left side of the Fermenter's layout is a portal showing all grape lots from a TO named GRAPE_LOTS_Not_Selected. The relationship I've set up is a auto reducing one, ie _foreign_fermenter_id DOES NOT EQUAL _primaryfermenter_id. See the attached file or screenshot for a better look.

In the center is a "drop area" (basically a container field where the user drags and drops a row from the portal to assign it to the fermenter ID of the current record).

On the right is a second TO from the GRAPE_LOTS table named "GRAPE_LOTS_Selected". This relationship is a simple _foreign_id equals _primary_id one.

OK, now that I've stated the obvious (more for my benefit that for you folks I assure you) my problem

Everything works as expected within the context of ONE record. The list on the left of available Grape Lots to assign reduces when I drag and drop.

However, all lots are available again for assignment the second you browse to the next record (in this case the next Fermenter).

I've tried a number of approaches using relationships to tag a record as "assigned" and to have it filter out of the left portal list after a drag and drop, but I've had no success. I feel like this is a pretty straightforward thing too, and I'm just missing something obvious.

Thanks in advance for any help you can provide!

Josh

PS Full access is available through the guest account of the stripped down file attached. No password needed obviously.

Juice_Clone.fp7.zip

[comment]

How about this way?

Juice_Clone.fp7.zip

[pinotblogger]

Comment, thank you so much!

So simple, yet not something I'd considered (GetAsBoolean).

Can I send you a bottle of E.V. Olive oil as a thank you? PM me if you're interested. Email me at josh at pinotblogger dot com if you're interested.

Thanks again!

Josh

Edited February 11, 2009 by Guest