Re: Base - relationships

Depends on how you want to input / display the data. Search (e.g. 
google) for Entity-Relationship diagram techniques. It's the method of 
graphically mapping & designing the database. E.g. Would a visit only 
happen once to any one house? In this case the house's street number 
could form part of the Visits table.
Regards Irné Barnard


FamiliaFrazelle wrote:
> 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! :)