I'm using version 2.01. IMy Operating system is Windows XP. I have been working through the beginers tutorial on the Openoffice Forum. I have strted my own database to keep track of my garden. I can't figure out how to insert a picture in my form without using code. I'm very close. 1) I have two table both with primary keys. The Photo table contains: ID INTEGER [INTER] ROSEPHOTO IMAGE [ LONGVARBINARY] ROSENAME TEXT [VARCHAR] ROSENUMBER TEXT [VARCHAR] The Rose table contains IDPlant INTEGER [INTER] PHOTO IMAGE [ LONGVARBINARY] NOTES TEXT [VARCHAR] ROSENUMBER TEXT [VARCHAR] ( AND MORE TEXT STUFF)
I have one form, it has a" image box" I open the Forn Navigator dialog, Selected the MainForm object,brought up a pop-up menu and select new Form. Renamed the the new form Photo. I open the the form properites dialog for the photo form. On the Data tab I set the following: Content Type= Table, content Photo, Navagation bar yes, Master Link = Plant ID, Photo, Rosenumber. CommonName Slave Link = ID, RosePhoto, Rosenumber, RoseName THEN I DID THE SAME THING ON THE ROSE TABLE Content Type= Table, content Photo, Navagation bar yes, Master Link = Plant ID, Photo, RoseNumber. CommonName Slave Link = Plant ID, Photo, RoseNumber, CommonName (((((( I can't figure out Why the Master Slave are the same ))))))) NOTE: I did not create a subform when I opened the database and I did not create any relationships in the beginning. 2.) In my table under the photo field, I see <OBJECT> . Is this correct? 3) My auto number is off by one number, It started at zero and I changed that to 1 and that was a mistake because the numbers are off by one. Can I fix this auto number? Thank you Maggie