Thank you - you are talking about Normalization? I will put in the effort
you suggest - and I think I knew better than to try it this way. This may be
why my learning curve has been so slow - I am afraid to jump in and create my
own and have instead tried for months to just "customize" the templates.
One last question - when using the combo-box scenario you earlier described
- is that a combo box for each field?
"Steve Schapel" wrote:Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9570-saving-values-from-dlookup-new-table.html
> What you are proposing would normally be regarded as an invalid database
> design. All of the Contact-related data should be stored in the
> Contacts table, one field of which is a Primary Key field, where the
> data is unique for each record. In the absence of any real-world data
> to uniquely identify each Contact, an Autonumber field is often used for
> this purpose.
> And then, in the Attendees table, *only one field* should be included to
> identify the Contact, and this will be the corresponding data to the
> Contacts table's primary key. In the Attendees table, as long as you
> know the unique identifier, you can easily retrieve the name, address,
> phone, etc, via a query based on both tables. You don't want the same
> data replicated in more than one table.
> I assure you that it will be absolutly worth every ounce of effort you
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9570
> put into understanding this concept.
> As to your form management of this data, this article may be of help...
> Steve Schapel, Microsoft Access MVP
> Ricky11 wrote:
> > Wow! Thanks for the quick help! I like the combo box idea and that is
> > probably where I will concentrate.
> > I started with a Contacts Management Template, customized and then added
> > most of an Event Management Template. Both have reports and forms working
> > off their respective tables (that I don't yet have the knowledge to
> > re-create). When I enter the FirstName and LastName on the Attendees form,
> > I want to retrieve the address and phone, fax, home phone etc from the
> > corresponding record in the CONTACTS table AND then save that in the
> > ATTENDEES table.
> > You must have tremendous patience to deal with rookies like me. Thanks.