Showing 2 field values in 1 field

[stefan569]

Hi, I'm building a invoice layout for printing and I would like to combine two field values into 1 field to reserve horizontal space for other fields. These fields are within a portal.

The values are in a related table to invoice, the portal is showing these values ok.

So I try to show the invoiceID within the portal:

<> and it shows perfectly.

Problem is I can't seem to show the related field eg:

<> shows the exact same thing for each row '<>' instead of my value!

Combining 2 fields

<> - <> doesn't work either.

I double checked the spelling and the field names are the same as in the relative table. What can my mistake be?

Edited November 26, 2009 by Guest

[Matthew F]

Welcome to FM Forums!

I'm building a invoice layout for printing and I would like to combine two field values into 1 field to reserve horizontal space

It might be easier to just set the 'Sliding left' option for these fields under the 'Set Sliding/Printing' menu item.

You state, "the portal is showing these values ok" and then later you state, "<> shows the exact same thing for each row". How many tables you are referring to and how they are related? It sounds like you haven't set up the relationships correctly but its hard to say without a more clear description.

[stefan569]

thanks for the welcome

I found the problem after searching more, I have to prepend the table name before the field!

like so:

<> - <>

******* still not solved, Now I have two numbers

1 - 3 these are the placeID's I want to get the place names =(

Edited November 27, 2009 by Guest

[comment]

I'm building a invoice layout for printing

Not related to your question, but it is best to print invoices from the LineItems table, rather than use a portal - see:

http://forum-en.filemaker.com/fm/board/message?board.id=FM-en-4&message.id=31436#M31436