Selecting object_name and returning object_ID

[Nicholas Lue]

I need quick help or a suggestion on what I should be looking at todo this specific task. I'm working out a simple many-to-many relationship and in a particular screen where I put an unique object into a specific group.

There is a dropdown box that lists all the values for Group_name.

When I hit ok, I would like to reference the group name against the related group_ID and use the ID to store the grouping, not the name. This way, if the name of the group changes, it doesn't ruin all my pairings.

For this relationship I have 3 tables, one is an object table, one a group table and one a object_group table.

[SlimJim]

Have a look at this thread

http://fmforums.com/forum/showtopic.php?tid/167304/post/167445/hl//#167445