By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Add child record using Not in list event

P: 25
Need some help with using the Not in list event. Several tables with one to many relationships and a M2M. Of these tables I have a customer table with a FK pointing to a City table. The City table has a FK pointing to a State table. All works well when adding new customer records provided the state with it's associated city child records have already been keyed into the tables - enter a new customer, select the city from a combobox and it auto-populates the form with the state name. I cannot for the life of me get the not in list event to add either a new state, new city or both. I have used the not in list even before with other tables that did not have relationships. Is what I'm trying to do possible or will it be necessary for a popup form of some sort with fields for the city and state related tables to have data entered directly into them?
Mar 28 '17 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.