Hello,

I have a sub-summary part used in a layout that works fine in the preview mode. This is an invoice application and each invoice has several items/per invoice. If I use the browse mode each item is a record rather than in preview each invoice is a record. Consequently, to delete something in the browse mode would require deleting every item on an individual invoice. Instead I need to delete one record that has all the item detail in it like I can do in the preview mode.

How do I delete a record while in preview mode?

Thanks,

Randal

Hi

while in Browse Mode, to delete the invoice, you have to go to that invoice; sure there is a layout where you can see the invoice.

thanks for the suggestion, but from what I know that won't work.

In browse mode I can't see the entire invoice making it much harder to know what record to delete. Especially,if there are multiple items per invoice.

That is why I need a solution while in preview mode.

Randal

Sounds like the layout that you're using is based on your invoice line items table occurence. Typically, an invoice is not printed using a sub-summary report.

Rather, an invoice is created in a layout based on your invoice table occurence. Line items are entered in a portal on the invoice layout.

When you print, a button on the invoice goes to the line items file and prints. However, you bring the invoice #, Date, customer info from the invoice as related fields in the header of the print layout.

Also, the relationship btw invoice and its line items is set so that if an invoice is deleted, its line items are also deleted (a cascading delete).

So, as said above, if you are on the layout that is based on Invoices, simply deleting the parent invoice will delete all the children line items.

Edited January 27, 200718 yr by Guest

Thanks for the suggestion. However, I am getting the data for this application from a flat .csv file.

I am not real familiar with FileMaker so I found another option. I have created a navigation bar in browse mode and tied the nav bar to our content that is displayed in preview mode.

My only problem is the nav bar delete record option won't work.

Is there anything I need to do different concerning having two windows you are working with when you want to delete a record?

I have all the other nav items working and I got this code as a free download at http://databasepros.com

Thanks again,

Randal

I think I know, but What's the name of the file?

i.e. NavBar.fp5( fp7), not the solution name.

Lee

Hello,

The files are NAV.fp7 and TARGET.fp7 it is a free tip file that comes from databasepros.com

Thanks for your willingness to help.

Randal