AutoEnter from a relationship.

[Rotorian]

Hello, I have 2 databases

DB1 and DB2 records are related by Field1. That is the relationship that is established in the relationships table. However, field4 is also related.

What I need is for when a new record is created in DB2 for field4 to be populated with the workorder# from DB1 field4 matchiing field1 on both databases.

I.e.

DB1 Field1 value is 559 with field4 wo#31959.

Now user creates a new record in DB2. He enters 559 in field1 of DB2. Now I need field4 to auto populate wo#31959 w/o user input.

I created a field in DB2 with autoenter "looked up value" from relationship field :wonumber (aka field4). So, a wo number is being put in place, but it doesnt match 559 wo# in DB1.

Pls help, let me know if you need more info.

[Rotorian]

Figured out my problem, wrong use of a relationship.