csharpmin Posted May 8, 2007 Share Posted May 8, 2007 I'm working on a database solution for my babysitting business. Things are coming along nicely, but I'm having a problem showing data in a portal. The portal is based on the table occurence Job_SitterAvailability. The portal should show what sitters are available for a given job. The 2 tables have 2 joins: JobDate=AvailableDate (which shows what sitters are a availble for a job based on date) and YoungestChild_n > ChildOlderThan_n (which limits the available sitters based on the youngest age child they are willing to sit for versus the age of the client's youngest child.) Job_SitterAvailability portal works fine with just the date match, the child portion makes the whole table occurence not work though. I should mention that both YoungestChild_n and ChildOlderThan_n are calculations based on related tables. I may very well have "evaluate from the context of..." tables wrong, or maybe it's a relationship problem. I should mention that if I replace the calculations with number fields, it works fine. I've attached a pretty bare-bones version of the file I'm working with. I highlighted the fields I think are relevant. I hope someone can help me. This has been frustrating me for days. Thanks Sitters_test_5.zip Link to comment Share on other sites More sharing options...
comment Posted May 9, 2007 Share Posted May 9, 2007 I got a little confused looking at your file. I think you need to lookup the sitter's age preference into the Availability table, so that it can be stored and used for a relationship. It's also sensible, in a way, since sitters can change their mind, and this will affect only future records in Availability. Link to comment Share on other sites More sharing options...
csharpmin Posted May 10, 2007 Author Share Posted May 10, 2007 I tried what you suggested by making it a lookup, but that still didn't fix the Job_SitterAvailability portal. Thanks for the suggestion though. I still need help. I'm not sure if the problem is in the relationship structure (Do I need a self-join?) or a problem with the related calculations that make up the relationship? In the included file I highlighted the fields and portal that are most relevant. Could anyone suggest any examples that base relationships on calculations from related tables? Link to comment Share on other sites More sharing options...
comment Posted May 10, 2007 Share Posted May 10, 2007 See if this makes sense. Sitters2.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6196 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now