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

creating all possible record combinations between two fields

January 10, 200223 yr

Newbies

hi...i'm new to FM...i'm running 5.5 at work if that helps.

i've got a master DB consisting of a sequence number (arbitrary number as primary key) along with a 'CourseID' field (foreign key) and an (EmployeeID) (foreign key)...each has their respective associated fields from displayed as well.

i'd like to know if i can somehow cut down on data entry by having the DB automatically create each combination of courseID & EmplID for me rather than entering each individually. from here, the sequence number increments for each new record.

for instance, courseID 1-EmplID 1, CourseID 1-EmplID2, CourseID 1, EmplID 3...etc. i have about 100 employees and 50+ classes to consider and i need a record for each combination. is this clear or too vague. please ask and i will clarify...

thanks again in advance...i'll post this in another forum as well. i'd appreciate any help smile.gif" border="0