My database training from books leaves me with many questions. I am building a billing table so I have a transID (auto incr), studentID (int), classID (int), clientID (int.. who is billed), cost (float), sessionID (int) and sessYear (char or int). Now I need a unique compound index of studenID, classID, sessYear, and sessionID so that a client can only be billed once for attending that class. Million dollar question, how do I do that? . something tells me that the transID is unnecessary but experience in fox pro tells me that in order to be able to update this record in a view I must have the transID as->key in order to specify the updatable fields.
Please help. Gary Jeurink --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1BCA7B25EC7D4EDCA3B1CFD3BB70F25E@OwnerPC ** 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.
