Hey All,
I am working with Base, seeing if I can create a fairly simple configuration for initial testing. At the start, I want to use the built-in Base Open Data Base file, but with the data I am going to be putting into the DB, I will eventually switching over to MySQL. For now, I just want to do something quick and dirty for personal use.
I am also looking to create something that isn't going to grow quite so large for the office, since I won't be using any Binary file holding fields in that DB for the office.
Below is the structure of two tables that I want to create and following that is the type of form I am looking to create. If you have any pointers, please send them my way.
PK = Primary Key FK = Foreign Key
CAMERAS (Table Name)
CamID Desc: Unique ID for each camera (Will be Serial Number off of unit) PK
CamName Desc: Common Name for the camera
CamMP Desc: Megapixels of camera
IMAGES (Table Name)
ImageID Desc: Unique Serial number for Image (Will be camera's filename for the image) PK
ImName Desc: Name of Image (If Applicable)
ImLoca Desc: Location shot was taken (Not Required)
ImDate Desc: Approximate or actual date image was shot.
CamID Desc: FK detailing camera used to take image.
ImApe Desc: Camera Aperture Settings (If Available)
ImShut Desc: Camera Shutter Speed (If Available) ImLense Desc: Lense used to take image (If Applicable)
ImFocal Desc: Focal Length of Lense (If Applicable)
ImFile Desc: Binary Field containing the actual Image
Virtually every single field of both tables with be a text field, for instance, the serial numbers often contain alphanumeric characters such as: ZQ345122-02154 (Made up example)
What I have done so far is create both tables, setup the relationship between both tables, populated both with some data, setup a view using all fields (Except the CamID) and also built a Query using all fields (Except the CamID).
Once I did all of that, I created a form using the Query, which allows me to see all of the data, no problem. It doesn't mix anything up improperly and performs the correct kind of join.
The problem I have is that the Form is setup to allow me to add new data into the DB, but it won't let me. The only thing I can figure is that there is either some problem with the way the join is setup The goal is to add new Image Data, reading the Camera type from the Camera's Table (Accessible by a pull-down menu or what-not) apply the CameraID to the image record and have no new Cameras records created or added.
What I believe it is trying to do is create new records in both tables, which causes some kind of error and thus the Form won't allow the entry of any new Records, period. I believe there should be a method to handle this, without having to program up an interface.
Thanks for any help, Robert Adkins
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
