Sign in to follow this  
Followers 0
TaiChi56

Table to print receipt

15 posts in this topic

I have a database for football inventory. I need to print out receipt for what the student did not turn in. First I want to make sure that I have my relationship set up correctly because I cannot seem to get the receipt to work properly. So here is what I have:

Table: Student

StudentID (Primary Key)
LastName
FirstName
Grade

Table: Inventory

StudentID (Linked with Students StudentID)
Shirt
Short
Helmet
Shoulder Pads
Practice Jersey
Practice Pants
Knee Pads
Belt

Table: Receipt

StudentID (Linked with Inventory)
LastName
FirstName
Shirt 
Short
Helmet
Shoulder Pads
Practice Jersey
Practice Pants
Knee Pads
Belt

 

Share this post


Link to post
Share on other sites

I don't fully understand what you are doing, but it seems you are set up incorrectly.  I think you should be more set up like an invoicing solutions where Receipt table equals a join table between Inventory and Student.  Receipt represents 'line items', and adding inventory is like adding line items, by lookup or calculation.  This could simply be a portal on the Students table.  Then reporting would be easier.

 

Share this post


Link to post
Share on other sites

Also: "I cannot seem to get the receipt to work properly." is extremely ambiguous. What exactly do you mean by this?

Share this post


Link to post
Share on other sites
2 hours ago, TaiChi56 said:

First I want to make sure that I have my relationship set up correctly

That's hard to tell without understanding what your solution is designed to track in real life. For example, are you sure you need multiple "Inventory" records for each student? IOW, do you issue the same kit to the same student more than once? I also suspect that tracking the return of the items could (and should) be done using the same record that recorded the initial issue.

Share this post


Link to post
Share on other sites

Posted (edited)

Yes, I am not sure either. I attached my database to show you what I am attempting. See if I am on the right track please. Thank you. 

 

Football_Inventory upload Copy.fmp12

Edited by TaiChi56
It had a password.

Share this post


Link to post
Share on other sites

The file needs to have User ID and Password?

Share this post


Link to post
Share on other sites

Posted (edited)

I thought I fixed that. Will it let you go to guest account and login?

I just checked it. You can log in as Guest. I gave guest full access rights. Thank you. 

 

Edited by TaiChi56
Checked on file then answered.

Share this post


Link to post
Share on other sites

Though a number of issues still remain, it is clear that the original relationship was incorrect.

See attached screenshot of the original and suggested revision.

Student to Join.png

student to join v2.png

Share this post


Link to post
Share on other sites

Thank you for that. I understand what you did. Not getting the inventory to show up under the students table though. I am working on that now. 

Share this post


Link to post
Share on other sites

I think you need to NOT work on it and figure out what pieces you need. As mentioned by Comment. Are you tracking individual pieces rather than strictly a kit?

What happens if somebody loses/breaks something and you issue a new one of those items. You can't do that now. You only have a complete kit or nothing.

Share this post


Link to post
Share on other sites

And for Comment's benefit, here is a very simple replication as an fp7 version of what is set up so far.

Football_Tai_Mod.fp7

Share this post


Link to post
Share on other sites

This is equipment that was issued to a football player. If they do not return it then I want to give them a receipt showing what they owe. If the lose it or break it then they still owe money. 

Share this post


Link to post
Share on other sites

That is not an answer to the question.

Share this post


Link to post
Share on other sites

Sorry. Yes we are tracking individual pieces not a kit. The student may not receive the same piece the next year as he progresses. If one is broken and lost then we replace it with another one. I hope that answers it. 

Share this post


Link to post
Share on other sites

So this really has almost everything in common with a standard invoicing system. Customers, products, orders, order line items, prices. And as with invoicing systems, it is sometimes common for orders to consist of a standard group of products.

1 person likes this

Share this post


Link to post
Share on other sites

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
Sign in to follow this  
Followers 0