Hi!
I have 2 tables. Invoice_Main and Invoice_Notes.
Invoice_Main has columns like Invoice_Number, Invoice_Date, Invoice_Amount, Invoice_DueDate, etc.
Invoice Notes has Invoice_Number and InvNotes fields.
I can obviously do many kinds of filtering on the Invoice_Main table. I am trying to "attach" the Invoice_Notes table to the Invoice_Main table so that as we filter the main table, we can add notes, etc in those fields. I've tried vlookups, filters, pivot's, etc, but all those just report on the 2nd table, and I am trying to add/edit the data in the 2nd table.
I think I am making this harder than it should be. Any suggestions?
Thanks!!!!
AC
Bookmarks