ACCESS FEED: Re: [MS_AccessPros] New Member With Question

Rabu, 18 Juni 2014

Re: [MS_AccessPros] New Member With Question

Thank you John! I had introductory Access in college, but want to learn it thoroughly. I picked up a couple textbooks from the library the other day and yours was one of them. Thanks! Another question, if you or someone could enlighten me what I might be doing wrong.

I have a series of statements enclosed in quotation for text validation, example: "Apple" Or = "Peach" Or = "Orange"

I was expecting the datasheet entry to automatically create the drop-down box when I entered in this particular field, but it is just blank. However, I do get an error if I attempt to enter something which it cannot validate. I can't seem to figure out what I might be doing wrong to not get the drop-down list.

Thanks,
Jerry in Michigan, USA

On 6/10/2014 10:07 PM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:

Jerry-

If a song can have one and only one copyright, then you have two choices:

1) Include the copyright info in the Songs table.

2) Create a 1-1 relationship between Songs and Copyrights with Songs as the "master" table. You do this by making SongID the Primary Key (Long Integer) of the Copyrights table.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jun 10, 2014, at 8:14 PM, Jerry bearjercares@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi everyone - thanks for allowing me to join your Access group. I have what I hope is a simple question. I'm creating a database of song titles of my favorite artists, but it will have at least 40 fields in all, pretty comprehensive, so I want to create more than one table - to prevent having one large table that might not be as easy to use. But I would like to have the primary key be SONG ID (autonumber) and include it the four auxiliary tables that I'm creating as well as the master table (plus copyrights table, recordings table, etc.).

Question is I want to be able to work with these different tables independently of the others by filling in missing information. I just need to have the SONG ID and SONG TITLE appear in all the tables as a major reference point when I create a DATA ENTRY FORM FOR THE VARIOUS TABLES. The problem I'm having, for example, is that when I create a Master Song Table that contains titles, authors and such and then create a table for copyrights that has referential integrity (primary key as SONGID in master and SONGID in copyrights table as FOREIGN KEY), it will allow me to create MANY copyrights for the same song - I want just one, so can I do a ONE TO ONE relationship instead of a ONE TO MANY? I'm confused, but I guess I'll eventually figure it out by continuing to experiment.

Thanks for any insight you can give.
Jerry in Michigan