Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

AutoEnter from a relationship.

Followers

March 6, 200619 yr

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.