First, are you able to connect to your MySQL database? I assume that the
answer is yes! More at the end!
Ramsey, Robert L 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
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
I would create the main form, create the sub form in the main form, link
the two forms based on a common key.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm
Free Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
