Invoice containing more than one Record Number

[bobcheg]

Hello all

I am working on a Database where each Record is a Job with a unique Job No but each Job could belong to a Range i.e.

Bakery-Italian. Bakery-French. Bakery-English. etc

I am trying to create an Invoice containing up to 12 items in a list, made up of, up to 12 non sequential Records in a Range selected by the user:

Job No

Range Title

Product Title

Size

& Total Cost,

which is calculated on a separate Costing Layout, these totals then need to add to a give Grand Total.

I have tried using a portal with different combinations of Relationships but I get either all records or none at all.

Help Please!

Also is it possible to display a large 'VOID' text or graphic field across the record, if the status of a job is changed to cancelled?

Thanks

BobCheg