One to one relationship

[Guest]

I'd like to define a one to one relationship between client and household.
When I make the connection between the two it always makes the connection one
to many.

I also have a situation where I have a list of Events and one Case Note per
event.
The Events are in a list form and the Case Note needs to be a large memo
text box. Making the listing tabular with a big memo box just isn't pretty. I
want the Event list to be scrolled and the Case Notes memo box updated
according to the 'date' row in the Events list.

Is this possibe?


Christian

 

[Allen Browne]

To define a one-to-one relation, add a unique index to the foreign key
field:

1. Open the related table in design view.
2. Select the field that relates to the main table.
3. In the lower pane, set the Indexed property to "Yes, No Duplicates".

How about using a Continuous form (rather than a datasheet), and putting the
Case Notes text box in the Form Footer section?

If that simple solution does not suffice, you can use the Current event of
your form to move the other form to the same record. (FindFirst in the
RecordsetClone, and set the Bookmark.) However, you are very likely to have
concurrency errors.