ER relationships

[darren...@iconglobal.com.au]

I would like to associate fields to one another where the relationship connector points to the field name within the table. From what I can see I can only associate table relationships. For databases the relationships are at field level and this is what I'm after.

Cheers,
Darren.

[rnrstar]

When I first started using RISE I was looking to manage the foreign
keys for related tables as I have always done but RISE actually does
that automatically for you by creating the necessary foreign keys in
the appropriate table. For example, in one model I have, I have a
table called "Form Groups" and it is simply a definition of a group of
forms. In another table I have the actual forms. This is essentially a
many-to-many relationship as I can have a form in multiple groups or
multiple groups with the same form. To accomplish this I have a table
called "FormGroupForms" with no fields defined by me.

Thus my model looks like, "FormGroups one-to-many FormGroupForms many-
to-one Forms." If you look in the actual table FormGroupForms, you
will find a FormsID field and a FormGroupsID field and nothing else.
Once I understood that, it made things really easy for not only design
but also coding the application.

Todd