Jump to content
Sign in to follow this  

Found set question - ghosts?

Recommended Posts

Hi all!

I've got a nutritional supplements db. With some advice from bcooney (thanks!) I've got it set up with separate tables for Supplements, Areas (i.e., health areas that supplement might support), Doses, etc., plus join tables with appropriate entries and a relationships graph to tie the tables together. So far, so good... mostly.

However, I've run into a problem. In the Supplements table (titled "Supp") I've got a field that indicates whether or not that supplement is currently part of the regimen. The field is named Current, and if the supplement is currently being taken, I enter a "y" in that field for yes, otherwise the field remains empty. Then if I want to work with just the current supplements, I do a Find for Current = y, which works as I expect it to. The problem is when I go to one of my other layouts, which is set up as a daily supplement report. Recently I replaced the supplement GABA with a product called GABA Calm. I added the necessary records for GABA Calm in the Supp table and elsewhere. I deleted the "y" in the Supp record for GABA and put a "y" in the GABA Calm record. I once again did a Find for Current = y. Now when I go to the report layout, I see GABA Calm, but GABA is still showing up too. Where is this ghost coming from? I was assuming that if I did a Find for all records where Current = y in the Supp table, that everything else I did would proceed with that found set. Am I wrong? What am I missing here? Any ideas gladly accepted.


Marcia Morrison

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.