Hi:I want to make a list of publishers. Each publisher has 5-10 or more books. I have a table for publisher and a table for books.I pasted all the script and the console view down but problem is:I made a form for the publisher registery and I have a filed that I can insert the publisher. But I need to enter many publishers name at the same time. I need a way to have several publisher text fields in my form that I can enter them at the same time for one book. If I can increase the fields (the way you can do it when you want to attach files into yahoo mail and you want to add more than 5 and down there there is a link "Attach More Files") by clicking on a link it will be ideal for me. Please please let me know how I can do such a thing.ThanksBenignMysql DB console view:mysql> use publishers;Database changedmysql> show tables;+----------------------+| Tables_in_publishers |+----------------------+| books || publisher |+----------------------+2 rows in setmysql> show columns from books;+-------------+-------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-------------+-------------+------+-----+---------+----------------+| BookID | tinyint(4) | NO | PRI | NULL | auto_increment || BookName | varchar(50) | YES | | NULL | || PublisherID | tinyint(4) | NO | MUL | | |+-------------+-------------+------+-----+---------+----------------+3 rows in setmysql> show columns from books;+-------------+-------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-------------+-------------+------+-----+---------+----------------+| BookID | tinyint(4) | NO | PRI | NULL | auto_increment || BookName | varchar(50) | YES | | NULL | || PublisherID | tinyint(4) | NO | MUL | | |+-------------+-------------+------+-----+---------+----------------+3 rows in setMysql DB scrip of my tables:CREATE DATABASE `publishers`CHARACTER SET 'latin1'COLLATE 'latin1_swedish_ci';## Structure for the `books` table : #CREATE TABLE `books` ( `BookID` tinyint(4) NOT NULL auto_increment, `BookName` varchar(50) default NULL, `PublisherID` tinyint(4) NOT NULL, PRIMARY KEY (`BookID`), KEY `PublisherID` (`PublisherID`), CONSTRAINT `PublisherID` FOREIGN KEY (`PublisherID`) REFERENCES `books` (`PublisherID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1;## Structure for the `publisher` table : #CREATE TABLE `publisher` ( `PublisherID` tinyint(4) NOT NULL, `PublisherName` varchar(50) default NULL, PRIMARY KEY (`PublisherID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;