On Fri, Jan 28, 2011 at 10:49 AM, Ken Dibble <[email protected]> wrote: > Here's one I have some preliminary ideas about, but I need help designing > the tables, and I really don't know where to start on the query. > > I have a pre-existing table of people that is already used for many things. > For the new feature, in some fashion, people in that table have to be > defined as "Consumers" or "Workers". People in that table may also need to > be defined as other things in the future. I don't want to alter the table > if I can help it, and I suspect that's not the right approach anyway. > > Consumers and Workers need to meet requirements before they can participate > in a program. > > Consumers and Workers can be assigned to each other in one-to-one > relationships before they meet these requirements. > > The relationship is "pending" if either the Consumer, the Worker, or both > does not meet one or more of the requirements. > > PROBLEM: I need a query that shows the relationships that are "pending". ------------------------
People Table P PeopleTypeTable PT PT is a many to 1 against People PT ID TID PID <date crap if you need it here> TID Worker Worker - not Confirmed Consumer Consumer - not Confirmed Let the "ID" designate their status and that can be changed by another process alltogether. Just trying to keep this simple. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
