I have a simple Point of sale databse with the main file housing customer info and the related file housing the stuff that they bought. I would like to be able to omit certin items they bought from the invoice (printed report). I'm thinking of a simple checkbox on each portal record line. If it is checked, that record is excluded from the report. If it is left alone, it is included like normal.

What I'm missing, of course, is the functionality.

I'm a intermadiate to filemaker, but new to version 7. Any thoughts are much appreciated.

Thanks

The database structure should be customer, order, line item, product. You can decide ahead of time which products you don't want to print. Then the line item will have a no print flag for that product. The invoice will print from the line items file (all records for that order number which don't have the no print flag).

If you would prefer not to do the above, you could add a part to your layout to hold non-print text. Then choose Format | Sliding/Printing | Do not print the selected objects.

So are you talking about nesting portals??? Seems fairly complicated. I like the idea of having different orders for each client, but what would be the difference between Line Item and Product why would I need to seperate them?

I guess my next question becomes this then: Currently I use the customers email address for the relationship field because it is something that is unique to each person. Would I use the same field for all of the different tables or would it be: Customer --> Order --> line Item --> Product (product only relating to customer via the other 2 tables?)

As I'm typing this it is slowly starting to make some sense, but I'd still like your (or anyone else's input.

Thanks again for your help.

Take a look at Chapter 7 of Stars' Learn FileMaker Pro 7 for how to do it.

Are you on commission for each sale of his book??

ROTFLMAO

You could create a relationship based on invoice number to invoice number AND a calculated field of 0 not equal to your related checkbox. Then Go to Related Record [show only related, "yourrelationship"] should find only line items that aren't checked, for your report.

No I'm a consultant, not a reseller. I don't make any commissions on the software or hardware (or books) I recommend.

I recommend the book because "Why reinvent the wheel?"

What is ROTF? I get the rest of it!

and thanks for your input on the original question. I'm going to start thinking about that today.

Thanks.

Rolling On The Floor

Thank you for your support!