How....

[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!

[Base]

Hey,

You should query them all and put them in an array dinamically, I think. Also you should create an event when a new Autor is slected he get the book info and displays that.

Hope this helps a bit.

[gardijan]

Please detail describe your solution. Query, dinamic list ... etc.

Thank You!

[Base]

Something like

 query = "SELECT * FROM Author, Book JOIN ON Author.ID_Name = Book.ID_Name"

open the recordset and than put the records in an array, until you reached the end.

[gardijan]

For example I have to fill informations about some book. So I know title and ID but ID_name (author name) which put in input text object but information about author I chose from combobox which contain all authors (Shall I use query now?).

Can you write me that piece of source?

Thank You!

[Base]

So you want to add new books to the db?

Then you should list all authors and give the combobox the value of author ID and the name in the combobox.

When I have time I'll maybe write soem code alltough I'm more a Javascript fan.