View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Automatic price update with size choice

Thread began 9/06/2009 12:08 pm by segufix361615 | Last modified 9/11/2009 10:15 pm by segufix361615 | 2579 views | 19 replies

CraigRBeta Tester

sorry if I went too fast

You don't need sizeid in the item table, if you think about it, each item can have more than one size, so this field is redundant.

tblsize is fine, as is tblprice.

sizeid in tblsize has to be unique

itemid in tblprice cannot be unique as you need multiple entries for each item.

If it makes things clearer, the combination of itemid and sizeid (a compound key) is unique for each row, but don't worry about that too much.

As you mentioned, your situation is slightly more complex, but not much.

Imagine you have a version table as well as a size table, it works in the same way.

tblprice now needs an additional field, versionid.

so for an item with 2 versions and 2 sizes, there would be 4 rows in tblprice for the same itemid, does this make sense ?

If you wish, you can pm me or send me an email (look at my profile or go to my website) if you want to discuss this in detail.

As far as the lookup query is concerned, this does take a little bit of hand coding, but I or the support guys at Webassist can help you with that.

good luck

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





Ease of use


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...