One form many table

marcja

Registered User.
Local time
Today, 04:34
Joined
Jul 12, 2006
Messages
12
Hi yall,

I want to create one form that'll populate many tables depending on the answer I gove to one of the from fields, which will be i a drop down box. I'm trying to create an organised diary!

So for example, if I put weddings in the from field it will populater the weddings table, portrait will populate the portrait table etc etc.

Only possible problem is that I will only want certain fields on teh form in certain tables. For example no real need for bride & grooms names to go into the portrait table.

Any ideas.

Many thanks.

M
 
Sounds to me that you should only have one table with a field that identifies the type of assignment. You need to read up on database normalisation.
 

Users who are viewing this thread

Back
Top Bottom