Re: Base - relationships

I duplicated your example, and it worked correctly. I entered a date, then
clicked in the visits area, and the date ID incremented to the next value
and that value was entered into the FKDate field of the first address
record. Since I can't duplicate your problem, I cannot help you.

John

On Wed, Sep 9, 2009 at 6:56 PM, FamiliaFrazelle <[email protected]>wrote:

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