Robert, I am no expert on this, but if you are digging into mysql, it sounds like you are on the right track.
OOo is different from MS-Office in that the database you choose to connect to is entirely up to you - and OOo will try to make your choice of database as transparent as possible - as long as you have a connector installed. I would be inclined to do the (form part of) what you are describing using mysql, but with a php (web server) user interface. That said, here are so pointers / howtos from others as to how to do it "the OOo way" http://dba.openoffice.org/FAQ/FAQ.html#subform I hope this is helpful On 9/23/05, Ramsey, Robert L <[EMAIL PROTECTED]> wrote: > > Hi, > > Hope this is the right list for this question. I need help setting up > database forms to access mysql tables. > > Here's the basic setup: > > 3 tables: > > Users - name, address, uid (uid is primary key) > User_specialty_join - uid, specialty (uid and special > Specialty_lookup - specialty <snip> What I want to do is have a form with a subform. The main form would > put in John's information, address, name, etc. The main form would have > a subform. The subform would be a listing of specialties from the join > table with the ability to add new specialties for John or delete > existing specialties. In addition, the interface for the subjform would > be a combobox that uses the lookup table as the source for the choices. > > I know how to do this in Access (it's pretty easy) but I'm having a > devil of a time figuring out how to do all of this in Ooo. I'm using > 1.9.125, the latest beta version. >
