Jump to content
Sign in to follow this  
wfcperrine12

Fields that contain data unique to each year and retained for future use

Recommended Posts

I'm pretty new to the FMP community so I apologize if this is not the right place to post this question. I am in the school fundraising business and I work with about 100 schools that do annual fundraisers (magazine, chocolate, gift, etc). Although my parent company does all the customer invoicing- I still wish to track year to year sales for each school.

My goal in FMP is to view each customer record in a layout that shows:

1.) the info that rarely changes (school name, phone, etc) and

2.) information that is unique to the current school year (which includes comparison to some of the previous years data).

I have over 105 fields that are unique to each school year. These fields then repeat for the new year. I wish to preserve the data for each past year so that it become retrievable for calculations.

My question is how do I do this - or how would you approach this with scripts or layouts. Here is what I have so far (see pic) but I don't think I'm on the right track with this. Any suggestions?

http://www.flickr.co...425/7830386606/

Share this post


Link to post
Share on other sites

How many tables does your solution include?

Share this post


Link to post
Share on other sites

1.) the info that rarely changes (school name, phone, etc) and

2.) information that is unique to the current school year (which includes comparison to some of the previous years data).

You should have 2 tables (at least) - Schools and Sales. In the Sales table, there will be a record for each unique school/year combination.

This is subject to the note below.

I have over 105 fields that are unique to each school year.

That seems rather excessive. I don't see this in your screenshot, but it sounds like you have many "like" fields that should properly be records in (yet) another table.

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 Terms of Use.