Access Microsoft Access Query in SQL

[wellsy4321]

I am trying to create a form that will allow me to input data into the Title Entity.

I have created a seperate entity called Author and created a relationship between Title and Author by using a CoAuthor Entity. This was to prevent a many to many relationship and also because a book (title) can have more than one author.

i want a drop down box so that i can select an author or a group of authors from the author entity (entity is the name for a table- so i am told). I cant easily do this using the combo button option so i reckon i probably need a query to resolve this. The query i tried was;

SELECT Author.AuthorFname +"-"+ Author.AuthorSname, Author.AuthorID

FROM Author, CoAuthor

WHERE Author.AuthorID=CoAuthor.AuthorID ;


When i run this query it produces a meaningless table.

The attached file has a screen shot of the relationships involved.

Hope i have provided enough information, and any help is greatly appreciated. Thanks

 

[wellsy4321]

I have just recieved the following advice;

Sorry for delay in response, try and implement the authors either as detail or as a seperate form:

1.Subform.
1.1 Header for Title (Columnar)
1.1.1 ComboBox for Publisher
1.1.2 ComboBox for Classificatio
1.1.3 ComboBox for UDC
1.2 Detail for Authors (Tabular)
1.2.1 ComboBox for Author (Last Name, First Name)

2. Two Forms.
2.1 Form for Title
2.1.1 ComboBox for Publisher
2.1.2 ComboBox for Classificatio
2.1.3 ComboBox for UDC

2.2 Form for Authors
2.2.1 ComboBox for Title & Edition
2.2.2 ComboBox for Author (Last Name, First Name)

2.3 Link the two via a Button.