Reply to thread

Message: [QUOTE="Alan, post: 11625579"] Sorry I wasn't clearer and thanks for the reply, Dave. My DonorNo has already been established and I will be importing the initial data in the Donors table from an Excel spreadsheet. The DonorNo is an 8-digit field consisting of first 3 characters of last name, first 3 characters of first name and a 2-digit numeric "tie breaker". This approach makes it relatively easy to assign DonorNos without much effort. I was thinking that when the user types the first 3 characters of the DonorNo (i.e., the first 3 characters of the last name), Access could provide a shorter list from which to identify whether the current donor already exists in the table. This is not an absolute requirement. I still need to know how to set up the form so that an existing donor's DonorNo can be selected from the Donors table or added to that table if new while also adding a new record to the Donations table. I'm thinking the NotInList event may be part of the solution but I'm stuck on what specifics will let me add a new Donor record to the Donors table if needed as part of the input form I'm designing to input new donations. Alan [/QUOTE]