January 8, 200917 yr 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
Create an account or sign in to comment