COMBO BOX , RELATONSHIP and QUERY

[gardijan]

Ok second time ask for answer. So I have two table
Author and Book

Author table have two fields:
ID_name (number, primary key)
name (text)

Book table tree fields:
title (text)
ID (number)
ID_name (number)

Retationship between table Author and Book is between fields ID_name (from Author) and ID_name (from Book). RS is 1:M

Ok this is MSAccess DB but now I need make form in HTML for input information about book. How I can make an combobox with list all authors from table Author thus when client chose name from list then script automatic fill ID_author in field ID_name in Book table.

Please write source or detaile directed.

Thanks!

[mvrp350]

I've never used it, but there's a project type called DHTML. I would suggest you use that one, add a combobox (or something like that). Next you can use ADO to connect to the DB and fill the combobox. Like I said I have never used it but I think it's worth the try.

[gardijan]

Relationship must be of more important significance. Why do we use relationship at all if not for decrament size DB and link separete information which make one unique entire.

Please help me solve my problem!

[Gaffer]

How is ID_author in field ID_name shown? On a form? in a textbox on a form?

[gardijan]

Client have not need see ID_name i.e. form need have one combobox with list of all authors name and chosen one of them. When client click accept button then in Book.ID_name field of this record put ID_name of chosed name.