Jump to content

Printing only fields with certain keyword


This topic is 2664 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am not sure if I should be in this forum or the printing forum. Here is what I have. I have an inventory database. Everything is done but I need to be able to print a receipt for any inventory not turned in. It is a student database so the primary key is the Student ID. I have nine fields that are filled out with either:

1. Not, Received, or Not issued. 

I want to be able to print out a receipt showing the student what they still owe us before they are cleared. I am just not sure how to do that. I was thinking maybe a script that looks at the field and only picks out the "Not" , takes that label and puts it on the receipt for example:

Geometry Book: Not 

So the script would see that the Geometry book has not be turned it and prints that out on the receipt. Hope that makes sense. Thank you. 

Link to comment
Share on other sites

Are you printing the receipt from the student record?

I would think you would use a script on the student layout that goes to the related records and constrains the found set to only show the 'Not Received' inventory items.

You could probably follow the Invoices starter solution to see how they print a list of 'Unpaid' items.

Link to comment
Share on other sites

This topic is 2664 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.