Invoice file containing batch numbers

[jfrick]

I have an Invoice file containing batch numbers. The Invoice.fp5 file might contain:

10 records where BatchID = 5001

16 records where BatchID = 5002

13 records where BatchID = 5003

I'm having a hard time creating a portal in my Main.fp5 that just shows the individual Batch information (in this example just 3 rows in the portal).

Any suggestions?

[Kurt Knippel]

Portals show whole RECORDS. Those "Batch Numbers" that you wanna see are just pieces of data in a field. You'll not be able to show only those three items since they are not records, but just elements of a record.

You'll need a different method for displaying them. How about a value list attacked to a global field? The Value List will display only the unique values in given field.

[jfrick]

Thanks captkurt, I ended up creating a separate file called Batch.fp5 which will act as a line items file.