PDA

View Full Version : Creating Forms using multi table recordsets


bigscousebear
04-27-2010, 01:34 PM
Is there anyway that I can create an input form from a recordset based on three tables. I'm new to Dreamweaver and my coding skills are very limited. Can anyone help, please?

davidj
04-27-2010, 03:53 PM
you want to populate 3 separate database tables with data from one form

bigscousebear
04-27-2010, 06:31 PM
Yes & No. I've created the recordset based on a order, order details & products. I need a insert record form that allows data to be entered. I can do it in Access no problem, but Dreamweaver is relatively new to me.

I'm teacher who has been lumbered with a unit at college. I've done everything else, but I'm having difficulty completing this last bit.

It would be good to learn PHP, but at the moment I don't have the time.

Thanks for the offer.

davidj
04-27-2010, 06:49 PM
Hehe

That's my signature. I wasn't offering my services as part of my post... Honest

Anyhoo..

Sorry I didn't read your post properly. I don't help with Dreamweaver code as there is no way to help without rewriting it.

edbr
04-28-2010, 02:11 AM
dont get on with acces and personally would advise mysql with php. from what i think you want you can dou this with the dreamweaver wizards, it just gets messy if you want to do anything out of the ordinary.
so you have 3 tables?
you want to update all 3 ?
how are the tables linked ?

need some more details ti think to grasp exactly what you want to do