data entry in related field problem

[acumagik]

First of all, i'm not sure if this is the correct forum, my question doesn't seem to fit any of the forums but this looked like the closest one.

I'm having a problem with data entry in a related field.

Here's the scenario:

The first table "AudioCD" has the foreign key _ArtistID

Another table "Artist" has the primary key __ID and stores the field "name"

The two tables have a one to many relationship.

I have allowed the creation of related record in the Artist table via the relationship

For data entry I have a layout called "Audio CD" based on the AudioCD table.

In order to enter the artist's name i am using a drop-down list associated with the _ArtistID field and an edit box displaying Artist::name

If I want to create a new record in the Artist table, I type the artist's name in the Artist::name edit box, but after moving to another field in the layout, the name disappears from the edit box. The _ArtistID (which is automatically entered) does not disappear. And once I commit the record, the Artist::name reappears.

This doesn't sound like normal behaviour. Does anyone know how I can fix this?

I'm using Filemaker pro 8.0v1 (the 30 day trial) on Mac OS 10.4.6

thank you

acumagik.

[Dr. Evil]

Hello,

sounds like you just may have had a small round'a'bout relationship problem. I have attached a sample file of a sound relationship structure, I believe it will help you sort out your issue.

MusicLibrary.fp7.zip