First i would create the things table. A table for the definitions of each "Consumers" or "Workers" and things. Then a relation between the people and a table that defines them as "Consumers" or "Workers" or "other things", in this table i would copy all the definitions. Some combo box, read only, would define
if they are C, W or P if all the applied conditions are met. I would put all this in forms and grids. HTH, E. > > 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. Thanks Stephen. That's an interesting idea. I need to look at it more closely. Even if I do that, I suspect I'm still going to have trouble designing a query that gets the report I need though Ken Dibble www.stic-cil.org _______________________________________________ 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. _______________________________________________ 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.
