I have 2 DB'S (NEV and NEV_Vans)with a relationship established via the record ID. When I put a new record in NEV_Vans I want some of the data in the fields in NEV_Vans to appeare in NEV. I have dragged the fields from NEV_Vans into the NEV layout. Now when I make a new record in the NEV_Vans and put data into those fields, and I switch to NEV nothing is showing up in the fields in NEV even though there is data in the NEV_VANS DB. What am I doing wrong here?

Thanks

Hi,

Things to check:

1. is the relation valid, does the current record in NEV have the same value in it's record_ID field as the new record in NEV_Vans?

2. check if the fields that you dragged from NEN_Vans to the layout in NEV really are the right field. Doubleclick them to check this.

Regards,

Ernst.

Hi:

Relationships work off of keys. RecordID would be your key. So, when you create a record in Nev_Vans, the RecordID has to be the same as the record in Nev in order to view related data. Also, dragging fields from related dbs won't work. To view the related data, put your field on a layout and select your relationship and then the related field.

Ken