value lists and anchor buoy

[laddaa]

Hello Forum,

In my file I have a table for letters and a table of persons. Each letter has one recipient

and is related to one project.

I read, that this anchor buoy thing is all the rage. So I followed that, as best I could.

I use a value list in in a pop up menu to have the user select the recipient. The first field

is the kf_ID of that person. The Second field (only this one is displayed) is the Name. That

is very smooth, since it is automatically sorted alphabetically.

As for the project I couldn't quite figure out things yet. I set up a field that calculates a string

which is used as a second field (number & ": " & "project_name"). In that specific file it just

doesn't sort correctly. (see attachment)

I set up a second file, just to reproduce the problem. In that file everything works as expected.

(i wasn't allowed to attach "this kind of file")

Where have I gone wrong?

Also, what general approaches are there? I use the first field for the foreign key, the second field

for the human readable data. Which will probably very often have to be calculated?

Thank you for any input or comment!

[Ron Cates]

To attach a FilMaker File you'll have to zip it first.