access relationships

[imp]

i has created a database in access 2000 with two tables named "author" and "books". "author" table contains following fields- authorid(primary key), firstname, lastname. & "books" table contains following fields- title, authorid, price, pages. there is a one to many relationship in these tables. now i want to do data entry. in which table i should do it? or i should create a new form to data entry. if in form i must do entry, so which fields should be taken in the form. please explain in detail and step by step and please reply very soon, if possible, so reply right now

[June7]

Since a book can have more than one author (collaborators) and an author more than one book (of course), this is a many-to-many relationship. This requires a junction table.

tblAuthorBook
AuthorID
BookID

If you want to limit each book to one author, then no junction table and put the AuthorID in Books table.

Data entry requires more than one form. Could do a form/subform arrangement. Main form bound to Authors, subform bound to Books. Master/Child link properties of the subform container control will synchronize the two. Access Help has guidelines on building this structure.