[AccessD] RE: design/development question on representing mtm relationships

On 1 Jul 2004 at 6:42, Robert L. Stewart wrote:

> Susan,
> 
> Ok, I see what you mean.  And here is how I handle such things.  There are 
> two methods.  All of the "lookup" type data, in your example, the 
> publisher, would be a drop down list in a combobox.  So, you would either 
> use the not in list event to be able to add it, or a button to the right of 
> the combobox labeled "Add" that would open a data entry form to do the 
> add.  I have done it both ways.  And, there are pros and cons for doing it 
> both ways.  The biggest con for the not in list event is that it makes it 
> too easy for people to enter things with an incorrect spelling.  

I never use  "autoadd" in the NotInList.  The NotInList event triggers a msgbox 
to confirm whether they want to add a new record  If they confirm, I open a 
modal Data Entry form with the entered data already filled in for the user to 
complete/confirm.





 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.