Base - relationships

[frazelle09]

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

[Irné Barnard]

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: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[frazelle09]

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: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
>

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

[jomali]

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 <frazelle09@...>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: users-unsubscribe@...
>> For additional commands, e-mail: users-help@...
>>
>>
>>  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!  :)
>
>