close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Using lookup tables - re administrative pages (in my industry updates app)

Thread began 12/04/2013 2:44 pm by david_allen | Last modified 12/27/2013 3:46 pm by david_allen | 6575 views | 10 replies

Jason ByrnesWebAssist

as far as lookup tables go, in the data assist wizard, on the Manage pages tab, go to the Field settings section

for the columns that will use lookup data, set them to use a menu as the display, click the lightning bolt to access the menu settings and select the loop table use, set the ID column and the label column.

what this will do is add a recordset to the page for be used to populate the menu and add a join query to the main recordset to lookup the label to display on the results page.

do this with a small sample to inspect the results and get a better idea.

Lookup tables are used to create a 1 to Many Data relation ship, the Relational tables concept is used for creating a Many to Many relationship. For example:

lets take the concept of Products and Categories. In some cases, you may set up products so that they can only belong to 1 category. This would use the linking table concept using a structure like this:

categories:
categoryID - Primary Key
categoryName

products:
productID - Primary Key
productCategoryID - Relates to categories.categoryID
productName
etc

in this structure the category is set in the products table so that the product is limited to belonging to only one category.

If you wanted to allow the product to belong to many categories, you would use a third relational table. the products table would not contain the productCategoryID column. you would create another table as:

productcategories:
productcategoriesID - Primary Key
productcategoriesCategoryID - Relates to products.productID
productcategoriesProductID - Relates to categories.categoryID

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