Related table field update -- newbie
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.