AnsweredAssumed Answered

Related table field update -- newbie

Question asked by PaulQuenzler on Jan 13, 2012
Latest reply on Jan 14, 2012 by PaulQuenzler


Related table field update -- newbie

Your post

I have a preferences table , has a serial #, a record I'd, a default event file Id , and a default chapter I'd.

Two other tables, events and chapters.  Each table has a serial, a record I'd, and other fields.


Only one preference record must many event records, and many chapter records.  For a given usage of the database, I want to browse events, select the event and use a button on that browse to cause the record I'd of the event to be placed in the preferences table.

Similarly, from the chapter table, browse to a desired chapter then again, a button to set the chapter I'd into the preferences table.

Structurally, I have the Id fields in contacts and events related to the same fields in the preferences table.


I am a newbie with some RDBMS experience with progress software corp language, but this is different.