close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Insert field value from joined tables based on form menu select

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

dan361748

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

Sign in to reply to this post

CraigRBeta Tester

I think I see what you are trying to do, but personally, I wouldn't.

what you would be doing is storing redundant data in your table.

your products table shouldn't need producttypeshortname as a field, as this information is already stored in your product type table and linked to your products table by producttype (producttypeid??)

Sign in to reply to this post

dan361748

Thanks - you are exactly right.

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...