On Wed, 06 Sep 2006 20:35:33 -0500 "Vernon Compton" <[EMAIL PROTECTED]> wrote:
> I tried asking this at oooforums.org, but have had no bites yet, so > here goes: > > I have created a small odb database to record visits made to > addresses by date and outcome. I have a dates lookup table and an > outcomes lookup table, and was rather proud of myself when I created > a form that rotated through my addresses allowing me to enter date > and outcome. Of course, the data I entered wasn't being stored > anywhere. This is obviously an embarrassingly rank newbie sort of > error, but I'm hoping that someone will take pity on me. Is there any > way to get the data that I select from the lookup table entered in > the appropriate data table? What I mean is this: if I select a date > from the lookup table, is there anyway to have that date entered in > the "Date" field of the "daily outcomes" table? Likewise for the > outcomes can I select those from the outcomes lookup and have the > result entered in the outcomes field of the "daily outcomes" table? > > Hi Vernon Don't be embarrassed by your lack of knowledge. Actually what you are asking is a reasonably advanced use of databases, in the sense that you are wanting to use relational databases, and not just a simple stand alone table. I don't know the answer to your specific question, but you will be needing to look up the relevant "help" files in OOo. (Choose the OpenOffice.org Base" section in the drop down box at the dialog box.) Since you are trying to access two tables in one form you will need to create a subform in your main form. I've looked around the documentation site (documentation.openoffice.org) and information on base seems very limited. I'm sure there is a suitable introduction in the user guide: http://documentation.openoffice.org/manuals/OOo2.x/user_guide2_draft.pdf Hope this helps to point you in the right directions -- God bless you, Keith Bates 4 Mooloobar St Narrabri NSW 2390 Phone: 02 67924890 Fax: 02 67925418 www.new-life.org.au If you don't have a reason to live JESUS IS THE ANSWER! Ask him into your life today... He really does make a difference. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
