print only inserted records
I'm using filemaker pro 11, I have a database where insert the code of a product and print some plates with the bar code and the position, is a way to print only the last inserted records?
On a single user system:
Show All RecordsShow Omitted Only
will produce an empty found set.
If the database is hosted over the network with multiple users, that method sometimes allows a record created at the same instance by another user to appear when Show Omitted Only is executed.
Instead use a find script that finds no records:
Enter Find Mode //clear pause check boxSet Field [YourTable::YourField ; //some impossible value goes here]Set Error Capture [on] //keeps records not found dialog from popping upPerform Find
It depends on the data in your table as to what comprises an "impossible value". It could be a negative number in a serial number field, "=" in a field that is never empty, or some other value....
Yes, but you'll need to find them.
FileMaker will print the found set.
this is exaclty what I want avoid
Filemaker gives you two options when printing, you can print just the current record or you can print the "records being browsed". This second option is what raybaudi described.
It's quite easy to work with different found sets in FileMaker, so I can't quite see why you would not want to print from the current found set. You can start with zero records in your found set. Add your new records and then, when you print, you can print with records being browsed to get just the newly created records.
but how can I start from a new sets?
it works even if I don't put an impossible value in a field, i put it in the search requests
Yep, I just prefer to use set field to specify scripted search criteria. That way I can come back at look at the script a month or two later and see exactly what criteria was used without having to open up another dialog, I can see it listed directly in the script instead.
understood, however thanks for the help!!
Retrieving data ...