Just a few days ago I finally started using Filemaker 8.

And I'm pretty satisfied. But I do have a little problem.

2 tables:

jobs

customers

I have a dropdown list on my foreign key field 'fkcustomers' in the table jobs to choose the customer (value list with hidden customer id).

To be able to see what choice I made and not an id number (because unfortunately the id doesn't stay hidden after closing the dropdown) I have a related field that displays the customers name.

Here's the problem. After making my choice in the dropdown, nothing happens in my related field until I click outside of the record. Only than the customer name appears.

I must be missing something. I've been changing the tab order but it doesn't help.

There must be a way to show the result without exiting the record, how do I solve this problem?

Prior to "exiting" the record, your changes have not yet been commited to the file, once you click out of the record however, the changes are commited to the file, thereby actually relating your current record to a child table so your lookup / calc will evaluate.

~Genx

I've noticed my question appeared twice in the forum. Very sorry this happened I thought something funny was going on when submitting it was very slow (15 minutes or so).

So there is no way to commit automatically after I've made the choice in my dropdown?

You could use the eventscript plugin, but i personally think its a bit of a waste of time though it does sometimes have its uses.

~Genx