Stumped by "grouping" relationship!

[gadsystems]

I'm actually stumped on this one....

I have a database of "companies"

I'd like the user to see a list of available "groups" as well as create and delete new groups, then next to it, I'd like to be able to "add the current company to the currently selected group"

I'd like some feedback on this... upon writing this it seems simple, there are some other "relationships" in the file that may be causing me problems, but I'm trying to take one step at a time to making this work. Thanks in advance for any help!

[Keith LaMarre]

lots of ways to do this - but it sounds like you may want to create a table of "Groups"

This would have a field called "GroupName"

Then, in your company file, you would have a field called Group with a value list coming from the "Groups" table - this would require you to add a script to allow a user to add a group as necessary (and possibly whatever other data is necessary to make the group useful)

You could also simply create a value list of groups that allows users to add new values to the list.

[Tim W]

Hi,

Layout focus could be an issue here. At least, a place to check out. TOG needs to include the companyGroup table TO.

Just a thought,

Tim