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

Calculation, Lookup, Best Way?

Followers

February 1, 200620 yr

Newbies

Currently I have two tables, Clients and Jobs. Clients is related to jobs through ClientID. Both tables have an auto enter serial field, ClientID and JobID. In the Jobs table ClientID is set as a pop up list, listing the clients entered in the Client table.

Eventually though there will be 300 + clients to choose from in that pop up list. Rather than scroll through that many, I want to be able to manually enter a client name and have a function that will lookup the correct clientID. Right now that only works if I specifically select it from the pop up list. If I simply manually enter the name and tab through clientID field in the Job table, it creates a new ID, and duplicates that client.

I'm attaching a sample file as well.

Any ideas?

Thanks!!

tyler_tdf_help.zip