Relation problem (can't describe it more precise)

[thorgil]

From a complete fm newbie (for like 2 hours) with a problem.

I have 3 fm-files with data (reference, publication, author) (I have more but solving this would solve the rest)

structure reference:

publication_id (number)

author_id (number)

structure publication:

id (number)

name (text)

structure author:

id (number)

name (text)

In reference I want a pop-up list of the authors name.

When i pick a value from that list I want author_id (in reference) to change to the corresponding value defined in author.

I also want it to work the other way around. If I change the value of author_id I want the selected value in the pop-up list to change to the value specified in author.

Same thing with publication but I guess i do that the same way...

The layouts of the database tables are fixed. (fm is used as an editing tool for a sql database).

Is it possible? (I can't get it to work) How do I do it?

This might be the simpliest thing in the word but I am under time preassure so I don't have the time to dig into the manuals (or this forum) to search the answer myself).

I also want a add author name button in reference but i think i can figure that out..

Any answers (or pointers) whould make me very happy.

/Tobias, Sweden.

[Fenton]

You need a Value List (under File Menu) for the AuthorID. Define as "Use values from field," then click the "Specify" button. In the next dialog window, radio button "All values," then "Specify File."

Use the navigation to find your Authors file. Choose the AuthorID as the field, then "Also display values from," choose the Author's Name (LastFirst calculation field).

Click the "Sort value list by, second field."