Newbie question...display records based on field value

From: Fred (koalabarry_at_yahoo.com)
Date: 10/31/04 

Date: 31 Oct 2004 11:41:29 -0800

My dbase has two types of 'customers'

They are 'players' and 'coaches.'

Both types are 'customers' and have several basic fields in common.

But each also has distinct fields.

How do I write the code that selects from the overall 'customers'
table only those records which have "yes" in the "coach" field?

Relevant Pages

  • Re: IPCS - where to get shop specific data
    ... A very common usage of that field is store some info about the level of the ... I don't see any compelling reason why customers would want to have to ... For IBM-MAIN subscribe / signoff / archive access instructions, ... send email to listserv@xxxxxxxxxxx with the message: GET IBM-MAIN INFO ...
    (bit.listserv.ibm-main)
  • Re: How many apps fail after installation?
    ... If I did, I could fix it, ... but I can't find a common factor. ... So when your customers say, "Doesn't work!", you just accept it at that? ... but so far those contacts are very rare. ...
    (microsoft.public.vb.general.discussion)
  • Re: deleting data
    ... I'm not clear what Special Customers are, what they have in common, why they are different to other customers, or why they are in a different table. ... If there are lots of other fields to keep for special customers that you don't keep for ordinary customers, you might need to create another table for those, linked one-to-one to your Customer table. ... The problem happen when the user deleted in the form one of the records in the query boud the the form that should be deleted from the SpecialCustomers table. ...
    (microsoft.public.access.queries)
  • Re: Newbie question...display records based on field value
    ... > My dbase has two types of 'customers' ... > Both types are 'customers' and have several basic fields in common. ...
    (comp.lang.php)
  • Re: Returning 2005
    ... Is there anything else common ... Do you have the same WiFi driver on all of them? ... Enabling our customers to move into the future without abandoning their past ...
    (borland.public.delphi.non-technical)