Question about book-catalogue

  • Thread starter Thread starter Gerard
  • Start date Start date
G

Gerard

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
 
Gerard said:
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?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.

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

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRR3ZS4echKqOuFEgEQL82ACfXCb+lIomztQRbXsjtpzMkvLNVw0AoMwW
ArgpvpMMTuslpEGxdALvt7Fm
=gq0+
-----END PGP SIGNATURE-----
 
Back
Top