Re: Base - relationships

Irné Barnard wrote:
> 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! :)
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
Thank you Irné for replying.  i was afraid that this would happen if i 
asked too many questions.  The only part i'm interested in/having 
difficulties with at this point i the last part...

   " 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!  :)