Originally Posted by
Ajax
[COLOR=#333333] i
On a form, use a combo for personality, combos have an event 'not in list' which can be used to open the form that controls creation of new personalities. That form should also allow for creation of personalities. The code that opens that form should also requery the the control to update the combo list with the newly added/amended/deleted records
You just need to be very clear that a relationship is not a join - but they use joins as part of the relationship, you have two interfaces showing different things - but in a similar way. when you open the query window, it's only interpreting the joins, which for complex relationships can present issues