Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Insert field value from joined tables based on form menu select

View all replies to this thread

Insert field value from joined tables based on form menu select

Thread began 8/15/2010 3:08 pm by dan361748 | Last modified 8/16/2010 5:38 am by dan361748 | 971 views | 2 replies

8/15/2010 3:08 pmdan361748

Insert field value from joined tables based on form menu select

Hi - wondering if someone can point me in the right direction here. Hopefully I will be able to explain what I am looking to do:

I have 2 tables joined, products and producttypes.

My insert form for the table products has a menu field populated by the producttypes table.

The products table has the following fields:
id
producttype
producttypeshortname

The producttype table has the following fields:
id
shortname

Right now, the field products.producttype is using as it's insert value the option selected for the form menu item producttype.id

However

I'd like to also insert into products.productypeshortname the corresponding value based on the user's selection.

Can you insert 2 values from a form menu item based on 1 selection?

Does this make sense? Any help, pointers would be greatly appreciated.

Many thanks
Dan

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.