I'm a cdml newbie too. I have a similar problem. I've tried the solution Garry Claridge sugested. And it works okay with the database. There's only a GUI problem. I guess because my 'Genus_id' field isn't unique.
I work with 2 tables/database files. A relations database and a company database. Those two are related by an id-key (called company_id in the relations db, id in the company db)
It comes down to this;
-company_id (not unique)
What I want to do is about the same as hdesport; to display a scrolldown menu in an editpage with the different company names in the value list, however selecting one should edit company_id.
As said the script shown above works, however the scrolldown menu displays company_names multiple times. This is because company_id is not unique. Is there a way to solve this problem?
Thanks in advance,