Relationship + not working on datasheet view

[Sue Compelling]

Hi,

I have a one to many relationship established [with referential integrity
and cascade updates] between my regions table [one] and my contacts table
[many]

From one users' PC, when you are in the datasheet view of the regions form,
you get the + sign - to allow visibility of all contacts associated with that
region, yet on another users PC their is no +. Can anyone please help me
with this 'set up' problem - really frustrating for a novice developer.

TIA

 

[tina]

when you are in the datasheet view of the regions form,

you get the + sign

are you sure you're looking at the datasheet view of a *form*? the only
place i've ever seen the "+" subdatasheet is in a *table* datasheet.
recommend you don't allow your users to enter data directly into tables -
that's what forms are for. a mainform/subform structure is the standard way
to set up data entry/display of tables with a 1:n relationship. also, many
experienced developers set the Subdatasheet Name property of their tables to
[None].

hth

Hi,

I have a one to many relationship established [with referential integrity
and cascade updates] between my regions table [one] and my contacts table
[many]

From one users' PC, when you are in the datasheet view of the regions form,
you get the + sign - to allow visibility of all contacts associated with that
region, yet on another users PC their is no +. Can anyone please help me
with this 'set up' problem - really frustrating for a novice developer.

TIA

 

[Sue Compelling]

Hi Tina - oops - how embarrassing. Thanks - this has solved my issue.
--
Sue Compelling

when you are in the datasheet view of the regions form,
you get the + sign

are you sure you're looking at the datasheet view of a *form*? the only
place i've ever seen the "+" subdatasheet is in a *table* datasheet.
recommend you don't allow your users to enter data directly into tables -
that's what forms are for. a mainform/subform structure is the standard way
to set up data entry/display of tables with a 1:n relationship. also, many
experienced developers set the Subdatasheet Name property of their tables to
[None].

hth

Hi,

I have a one to many relationship established [with referential integrity
and cascade updates] between my regions table [one] and my contacts table
[many]

From one users' PC, when you are in the datasheet view of the regions form,
you get the + sign - to allow visibility of all contacts associated with that
region, yet on another users PC their is no +. Can anyone please help me
with this 'set up' problem - really frustrating for a novice developer.

TIA

 

[tina]

you're welcome

Hi Tina - oops - how embarrassing. Thanks - this has solved my issue.
--
Sue Compelling

when you are in the datasheet view of the regions form,
you get the + sign

are you sure you're looking at the datasheet view of a *form*? the only
place i've ever seen the "+" subdatasheet is in a *table* datasheet.
recommend you don't allow your users to enter data directly into tables -
that's what forms are for. a mainform/subform structure is the standard way
to set up data entry/display of tables with a 1:n relationship. also, many
experienced developers set the Subdatasheet Name property of their tables to
[None].

hth

Hi,

I have a one to many relationship established [with referential integrity
and cascade updates] between my regions table [one] and my contacts table
[many]

From one users' PC, when you are in the datasheet view of the regions form,
you get the + sign - to allow visibility of all contacts associated

with
that

region, yet on another users PC their is no +. Can anyone please help me
with this 'set up' problem - really frustrating for a novice developer.

TIA