RelationShip one-to-one

[drikoudis]

Hello, i want someone to help me. My problem.... I have a Table [PATIENTS] for the patients, another for the visit, i said [VISIT]. They have one-to-many relationship. A third table [SOMETHING] have relationship one-to-one with the [VISIT] table. Now my problem is when i try to make a form with Tabs (first tabATIENT, second tab:VISIT and third tab:SOMETHING)i appoint master detail the [PATIENT] table, everything work OK accept that i cant post the ID from [VISIT] table to [SOMETHING] table in field VISIT_ID. Can anyone help me?

Sorry for my English, if you can not understand something send me a mail. Thank, John.

 

[willir]

Hi John drikoudis

In the process of trying to understand I guess my first thought is ponder why you need so many one-to-one relationships.
[tt]
PATIENTS VISIT SOMETHING
PatientID -> PatientID
VisitID -> VisitID
[/tt]

The short answer to problem / question is that the PatientID is avaialable on the main form. Your SOMETHING want to access the VisitID which is on VISIT subform.

Normally, you usually include only tables / data that directly relate the main form. You met this criteria but in and indirect route.

You can probably directly reference the subform to achieve this...

[tt]
[form]![YourFormOrSubFormName]![YourField]
[/tt]
Specifically,[tt]
[form]![VISIT]![VISIT_ID][/tt]

Hope this gets you one your way.

By-the-way, it is unusual to have one-to-one relationships except for very special cases such as confidentiality - a public table and a private table.

Although there are other reasons for using one-to-one, are you sure this is the correct design?


Richard

 

[TheAceMan1]

How are ya drikoudis . . . . .

Have a look at ther following:

[blue]Normalizing Tables[/blue]

http://support.microsoft.com/default.aspx?scid=kb;en-us;209534&Product=acc2000

[blue]Table Relationships[/blue]

http://support.microsoft.com/default.aspx?scid=kb;en-us;304467&Product=acc2000

See Ya! . . . . . .

 

[drikoudis]

Dear Richard and TheAceMan1 thanks very much for the help, it was useful.


John.