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 Users can have many specialties. The join table links the user to the various specialties. Lookup is just that, a lookup table filled with the set of available specialties so that users can pick from pre-defined specialties. Data would look something like this: USERS: John 1 Jane 2 Joe 3 USER_SPECIALTY_JOIN: John English John Greek Jane French Joe German Joe French John Japanese SPECIALTY_LOOKUP: English Greek French German Japanese Chinese 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. I'm I right in thinking there's no way to say that a subform source is an existing form? That's how you do it in Access: create form A, then create form Main. You insert a subform control on Main and tell it that the source is A. I couldn't figure out how to do that, and I'm not sure whether it's because I'm so new to Ooo or if it just isn't possible. Thanks for any help you can give me, Bob --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
