total records of present month

[karenjoy]

Hello All,

I'm very new to the forum and this is my first post, I'm a Lab Pharmaceutical technician and we purchased Lab reagent for our Projects. we purchased a filemaker to monitor the expiration date of our reagent.

Almost everyday I'm reading the forum and browsing the net, I found some that is suited to our needs, but there is one thing that I cant make it work, to display all the total numbers of our reagent that is expiring for the present month and also to display their names using portal via relationship. (see tab for expiring next month on the Dashboard) please help me to accomplish this. I tried playing of the relationship but cant get to work.

 

Please find attached link of my work. the User Name is Admin no password. 

Thank you so much in advance.

Karen Joy

Edited October 23, 2014 by Lee Smith
Font size

[Lee Smith]

Hi Karen, and welcome to the FM Forums,

 

Please post your files here. If you don’t know how to do this, just follow the steps you will find here. Attach a File

If you have any questions about this, just contact me by Private Message.

[eos]

display all the total numbers of our reagent that is expiring for the present month and also to display their names using portal via relationship.

 

Have a look at the attached modification.

 

btw, there's lots and lots of repetition going on in your DB; also take a look at how to unify your colour coding, and simplify your calculations.

 

User Name is Admin no password. 

 

Which you could haven entered yourself as default credentials …   btw, please always zip your database files before posting them.

Reagent Monitoring_eosMOD_compacted.fmp12.zip

[karenjoy]

Hi eos,

 

First of all I would like to thank you for your patient rebuilding my work, thank you for the tip.

I will highly appreciate if you can also change the calculation of reagent expiring this month because if I put a date for the next month

the expiring this month alert is changing too.

 

Again thank you so much.

 

Karen Joy

[karenjoy]

Hi Lee and to all members of the forum,

 

I'm sorry for that and thank you for giving me the direct link steps on how to upload a file to the forum without using any external link.

 

Karen Joy