Multi-record using tables that have multiple options

Hey,

You'll need to setup your table list in a multi-record section first. If you want to include them in the original multi-record in CMS Builder you can use the "Related records" field type. That is an advanced feature requiring a little knowledge of sql.
If you want to display them on your web front end, then you can pull the table list with a load records statement. This option will be much easier.

Hope that helps,
Robin

Yes, this is what I am looking to do. But I don't have the knowledge of sql. I was told this was the best option and that someone could help me through this feature here in the form. Thanks.

Hey,

This seems related to the problem you've mentioned in the other thread?
http://www.interactivetools.com/forum/gforum.cgi?post=87716#87716

I can help you with the sql if you setup the tables first and then let me know what the table/field names are.

Thanks,
Robin

Yes, this is directly related and I am happy to close one of these threads. THanks.

Okay, well I started fresh here and created a multi-record table called all_products

Then for each product, I have a multi-record table that has a different name (each one has a different name for the product, so there is one called bulb_specs for instance. Each specifications table has varying fields.

For all_products, the fields are:
title, content, features, specifications_copy, specifications_notes, support_info, videos, documents, support_links, product_main_description, image

for bulb_specs, the field names are
item, description, product_length
==========

I am honestly now wondering if there is an easier way to do this, such as including the tables of product specifications right within all_products. That way, if the user wants to create a new product, they would be able to create specifications within.

But I don't want to just create an HTML table here, because I like the sortorder functionaltiy, as it makes editing the specifications listing easier.

Any and all help is appreciated.

Hey Kim,

Adding the specifications within the products table its a good and easy option. You could do it in a wysiwyg field and not have to worry about table relationships or anything like that.

Robin

Yes, but there's no drag and drop option this way, correct?

It seems to me that someone who doesn't know HTML very well might have a difficult time placing the rows where they want if we use a table format within the wysiwyg. Is that what you meant? Or is there a better way to do this?

I just tested it out and putting in a table I couldn't even add rows or columns to what I had originally selected, so if this is the way it works, it definitely wouldn't work for our needs.

But honestly, I think I need the ability to easily add rows or columns in between existing columns or rows without knowing HTML, which is why this was originally a multi-record entry. So if we can't achieve this in the main product, then it would be better, I think, to combine two multi-records, which I'm still unclear on...