I am attempting to run Base as a front-end to a MySQL database which
contains multiple tables. I've managed to connect Base to MySQL
successfully.
The first table ('table1') contains the 'main' data for each record.
While most fields in table1 accept freeform manually-entered data, two
of the fields in each record are intended only to take on values which
are given in the appropriate fields within two corresponding
'secondary' tables (let's call them table2 and table3).
I have created a form, using the wizard, to allow data entry for new
records.
For the first field which takes its value from one of the 'secondary'
tables, I have changed the (default) text box into a list box. So far,
so good.
However, I don't know what I need to do to set up the list box
correctly to take on the appropriate values from table2 (let's call the
corresponding field 'category'). The necessary values are already
present in the 'category' field in table2.
My first point of confusion is: Do I need to amend the default values
in the "Control.." or "Form.." context menu entries, or both?
The "Data" tab in one, or other, or both(?!) of these dialog boxes is
presumably where the main action is at.. I suspect I may have to tweak
some of the "General" values as well?
Is there somebody who would be willing to talk me very slowly and
carefully(!) through what I need to do?
Basically, I want the user to be able to select a value for
table1.category from this listbox, which has as possible list options
the categories which are present in table2.category (and the same, in a
different listbox, for table1.somethingelse from table3.somethingelse).
(I see listboxes in the dialog boxes with such values as "Valuelist",
"Table", "Query", "SQL", "Tablefields", and have no idea what I am
supposed to choose! I do understand SQL to some degree but the use of
terms in this context confuses me, as what are obviously highly-
specific meanings are not clear..)
Any help would be very gratefully received,
Thanks,
David.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
