11 years ago
0
Topic

Hello again Sebloders,

Here is something that I've run across in building my first application. Just wondering if anyone knows of a technique to fix or adjust this.

-------------------------------------------------------------

I have a Concat field in my form that creates my Article's TITLE.

For example:
Make: Dodge (Dynamic field pulled from the Manufacturer's table)
Model: Ram (currently a regular text field.)

concat field uses:
#com_make# || #com_model#
and it's saved in article >> title

All is wonderful. When I'm looking at my list of articles there is a nicely formatted title called, DODGE RAM

Then I decided that to make more efficient use of database space, have my MAKE field be a RELATED field.

I set it up as a related field, it's linked to my MANUFACTURER category and it works wonderfully in the form. Just like the regular Dynamic field, it allows me to choose my Make.

The problem comes when it Concats to the TITLE column.  Now that I'm using a related article field it saves the ID of the manufacturer instead of the name of the manufacturer.

Now the title looks like this "14 Ram"...

I want to avoid having the same field in a form twice (One dynamic to create the title and one related to create the relation) so my question is, does anyone know of a way to have it SHOW UP as the Name instead of the ID?

I need the related field because on my Manufacturer's List, there will be a list of all the models in the database for that manufacturer. (See creating related articles video by James Morrell)

Any ideas would be greatly appreciated.

Thanks in advance.

- dniezby

Get a VIP membership