[users] Database Help with OO 2

[Troy T. Hall]

Hello, I"m new to the list and just downloaded OO 1.9.79.  I'm having a 
heck of a time with the database.  I need to create a database that has 
3 tables.:

( TABLE 1 )      WHEEL ID TABLE ---  Contains images of each type of 
wheel possible -  Each is Unique
Fields               Characteristic
=====================
WheelID                     varchar-ignorecase 8 length  Pri-key
WheelName                 Varchar-ignorecase   50 length
WheelPic                     IMAGE
WheelYear                    Date (YYYY)
----------------------------------------------------------------------

=================================================
(TABLE 2)      Car Image table      ----           Contains images of 
each car  - Each is unique
Fields                     Characteristics
============================================
CarSeriesID                     Varchar-ignorecase 8 length     >  Pri 
ID ( pt1 ) - ( one of the characteristics that makes it unique )
CarNameID                      Varchar-ignorecase 8 length    >  PriID ( 
pt2 ) - ( one of the characteristics that makes it unique )
CarSeries                     Varchar-ignorecase  50 length - ( one of 
the characteristics that makes it unique )
CarName                     Varchar-ignorecase   50 length - ( one of 
the characteristics that makes it unique )
SeriesNumber                  tinyInt
ColNumber                     tinyInt
CarYear                          Date(YYYY)  ( one of the 
characteristics that makes it unique )
CarImage                        Image - ( one of the characteristics 
that makes it unique )
CarVariation                    Memo  ---- image title text that helps 
id the unique characteristic of each car. - ( one of the characteristics 
that makes it unique )

/Any of of these things could be different and that would mean a new 
record would be required.  There are literally thousands of variations, 
but often only a few each year/car/carID/
------------------------------------------------------------------------------------------------------------

=================================================
( TABLE 3 )                  Car Value Table   --- List of each cars 
value characteristics  --- Each is Unique
Fields                             Characteristics
===============================================
CarID                           ( Table 2 ) PriID 1 + PriID 2
WheelID                       (Table 1 )
Condition                      ( Either is "MOC" or "Loose" )  No other 
condition matters
Cost                              Currency 8 length
Value                             Currency 10 Length
-------------------------------------------------------------------------------


The final form would include all of these fields to be filled out.  The 
main problem is how to handle the image database.  I don't seem to be 
able to create a table that lets me have an image that I can simply c/p 
into.  Can someone please point me in the proper direction?  Perhaps get 
me started on this?

Thanks Troy







---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]