Question about book-catalogue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerard - 29 Sep 2006 10:13 GMT

I am making a catalogue for a small library. The books come in one of x
bookcases. How can I indicate, in a tabel in which there is a choice
between table 1, table 2, table 3 etc. that one of these must be ticked
(in a "choice-round" for example) but not two of them can be ticked at
the same time, if you can understand my poor English?
Kind regards,

Gerard

Reply to this Message

MGFoster - 30 Sep 2006 03:41 GMT

> I am making a catalogue for a small library. The books come in one of x
> bookcases. How can I indicate, in a tabel in which there is a choice
> between table 1, table 2, table 3 etc. that one of these must be ticked
> (in a "choice-round" for example) but not two of them can be ticked at
> the same time, if you can understand my poor English?

If I understand you correctly, you need to change the design of your
table. It should be something like this:

CREATE TABLE Catalogue (
book_title TEXT(125) ,
bookcase_nbr INTEGER
)

The data would look like this:

book_title bookcase_nbr
==================================
Home Improvement 2
Do It Yourself 3
Shopping With Alice 1

Now you can have only one bookcase per book.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

Reply to this Message