INSERT INTO database, with bound and unbound boxes in form.

I have a form that I want to use to add jobs into a main 'static' database, I call it static because It will never change, only be added to through the years.

The form has a txt for a shop number that related to a shop number table, this txt calls up the shop details on update so this means the address, postcode and phone number are all bound to the shop number table. There are also numerous unbound txt boxes in the form that information is entered into.

What I need to do is take all the values from these text boxes and insert them into the static database, I can only presume that SQL is the best way to do this??

Any help would be great, Or any examples of insert into code.

many thanks pete

Pete,

I will send your database back later today. It is completed with the two requests you had.

lwells