Fred Frazelle wrote:
This is the second time i've sent this, but i don't see it
appearing in the Digest. i'm going to format it as Plan Text and see
what happens.
i hope this is the correct forum for this...
i'm still trying to get this to work...
i've created two tables: Dates and Visits. This is a bare-bones
setup to see if it works. The idea is to input info from visits to
homes into the Visits table. Since many visits to homes are made on
the same day, it would seem reasonable to NOT include the visit date
in the Visits table, but make a separate table for it and relate it to
the Visits table in a one-to-many relationship.
If i can get this to work, it would also seem reasonable to remove
the Neighborhood name and the Street name from the Visits table and
place them in separate, individual tables as well, since they are
repeated values in the Visits table (many addresses on the same street
and many addresses in the same neighborhood).
So, i created the following:
Dates table
IDDates, Primary, Integer, Autoincrement
Dates, DateType
Visits table
IDVisits, Primary, Integer, Autoincrement
Street, Text
FKDate, Integer, Input not Required
My questions are these:
Are these sufficient fields? If so, how should i Relate them in the
Relationships window so that when i input a new date in the Dates
Table the corresponding Foreign Key in the Visits Table will
automatically receive a new value?
i've created these tables and the relationship in Tools,
Relationship, and then tried to create a form but when i got to input
info through the form, i can input the first date and the FKDate
control appears as 0 (zero) which is correct and corresponds to the
first IDDates value. Then, i can continue to input new records
alright. But, when i try to input another date, the control will
accept it, but when i change to the Visits area, the FKDate field
doesn't increment to a new value, it remains zero. What am i not
doing correctly? Or is Base not capable of this type of input?
Have a great afternoon! Smile
Your messages are getting through but perhaps you don't know to whom you
are sending them. We are not a company support desk. Instead we are
merely users of OpenOffice, around the world, who volunteer time to help
others. It may just be that nobody who can answer your question is
currently reading the messages.
You might be better off asking in the "Base" section within the OOo
forum. It's at <http://www.oooforum.org>. You need to subscribe (free)
before you can post questions or answers. Like this mail list it's run
by volunteers but tends to be more specialised.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
