On a form that has all ready been design, user needs form to be able to only have to input company name once and be able to input many chemicals. Can this be done without having to build a new database?

I am sure this can be done; however, need more information as to db and table structure in order to point you in the right direction. Please reply, an restate your question more clearly.. I will try to assist you as best I can.

Thanks

jeff

Thanks for your reply. Have a table with fields for a company and the chemicals it uses. The form allows user to input a company and the chemical it uses. The problem is if the company uses 20 different chemicals, the user has to input the company (same) information 20 times. Would it help if I also send you the database? Again, thanks for your help.

I am thinking you need two tables one for companies(and their info) and one for chemicals..

Maybe something like this

table1
CompanyID
COmpanyName
CompanyAdd
Etc, etc

table2
ChemicalID
COmpanyID
CHemicalName

If you like please send me a copy of your db, and I will take a look at it for you...

HTH

Jeff

Your right, it can be done if we redesigned it. My question is is there a way I could do it without building another database. How do I send this database to you?

You must redesign the database. Sorry, but I'm pretty sure about it. You could make a form that automatically duplicates the data from the last record when you go to a new record so that the user wouldn't have to but that, I feel, in your case, would be stupid. You would still be duplicating the company data in the table, wasting space, and paving the way for anomalies. Properly normalizing your data, is in my opinion, the most important part of database design. I don't think that normalization is normally stressed enough, and unnormalized data will always be the cause of countless pain and suffering.

I figure that was the only way. I wish I saw the database before company started inputing data in it. Anyway, thanks for all your help.