View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Database Setup Multiple Tables and Multiple Options

Thread began 12/17/2009 1:12 am by jo4koalas392067 | Last modified 1/19/2010 1:35 pm by jo4koalas392067 | 1615 views | 7 replies

Jason ByrnesWebAssist

This really is not a small project, it is a very large one.

To be honest, due to some of the limitations you mention, it will require a fair bit of and coding to complete. It is not a project I wold recommend as a way of becoming familiar with DataAssist and relational data.

This is going to require created Lookup recordsets. Lookup recordsets are used to get one particular record to return the ID.

It is going to require createing recordsets nested in other recordset repeat regions.

Where you cannot use multiple select lists or checkboxes, you will need to add ajax functionality to create an input box to display information from the database based on what is typed into the box.

I would start with using the data assist wizard to create pages for the Companies table.

On the detail page, add a link to a new page to manage the occupations / locations.

Use a querystring to pass the company ID.

add a hidden form element that will get the value passed from the quertystring.

You will really only be able to add one ocupation / location at a time.

The ocupation list is where you will need to use ajax functionality, we do not have a tool for this, but you should be able to find something through google.

When they select an ocupation, and a location, create a recordset to lookup in the occupationlocations the selected ocupation / location and return the occupationlocationID

This will be store in the employeroccupationlocations.occupationlocationOcupation ID table.

The employeroccupationlocations.employeroccupationlocationsEmployerID will get the value from the hidden form element.

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