We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content
Sign in to follow this  
TaiChi56

Table to print receipt

Recommended Posts

TaiChi56    0

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
BruceR    151

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
comment    1,357
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
Lee Smith    142

The file needs to have User ID and Password?

Share this post


Link to post
Share on other sites
TaiChi56    0

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
BruceR    151

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
TaiChi56    0

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
BruceR    151

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
TaiChi56    0

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
TaiChi56    0

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
BruceR    151

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.

  • Like 1

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  

×

Important Information

By using this site, you agree to our Guidelines.