Relationship to show different data in different tabs

[TASC]

Hi ,

I'm a newbie to 9. I have attached a file to better describe my question.

I have two tables: Invoices and Attachments.

Each invoice can have may attachments but one attachment can only be linked to one invoice.

Each attachment can have a status of either Active or Inactive. At any point in time, an invoice may have both active and inactive attachments.

I want to show the Active attachments on one TAB and the inactive attachments on a separate tab related to each invoice.

How could I do this?

attachments.zip

[RalphL]

Take a look a the attachment.

attachments.fp7.zip

[TASC]

Thanks, that seems to have done the trick!