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
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

How to create 2 distinct records in a table from the form of a related table?

Featured Replies

  • Newbies

New to filemaker, I'm discovering relational databases but getting stuck

I'm creating a small database for the necessities of a golf match play championship. I've created 3 tables:

-players (name, first name, tel, email, adress, etc)

- individual rounds (id round, date, name, first name, gross score, net, ...) (NB 1 round per player)

-matches (id match, result match, score match,id round 1, name player 1,id round 2 name player 2, score 1,score2, etc)

I'd like to link the 3

The link between players and rounds is fine: the info from my players records appears correctly when I fill in the last name.

1st request: is there an "auto fill" feature whereby while typing, the name auto fills until I validate the field?

2nd request concerning the match table: I get stuck: I would like to be able to fill into an single form the results of the match AND the individual scores of each of the players (including different stats on their quality of play: number of shots, fairways hit, greens, putts, bunkers, with points attributed). TWO distinct records would therefore have to be created in the "individual round" table (one for each player) but only one in the match table. I Have added a screen shot of the type of form I would like to be able to use

I have two distinct "id player" fields in my match table (one for each player) that would need to link to specific records created automatically in the "individual rounds" table as the form was created. But FMPro asks me to duplicate tables in the relationships pane, and the I lose it... I have checked the boxes allowing the creation of records in linked tables but somehow it doesnt work.

3rd request: To be able to navigate in the form between fields I have activated tab "browsing", works ok BUT I would like the tabulation to follow a specific order. How can I specify which field gets activated after another when I tab?

I've added screenshots of the match form & the relationships pane

What am I doing wrong? nothing works ;-(

HELP! & thanks!

post-105473-0-26819200-1318081098_thumb.

post-105473-0-02386200-1318081290_thumb.

3rd request: To be able to navigate in the form between fields I have activated tab "browsing", works ok BUT I would like the tabulation to follow a specific order. How can I specify which field gets activated after another when I tab?

This should help you:

http://www.filemaker.com/help/html/edit_layout.10.30.html

1st request: is there an "auto fill" feature whereby while typing, the name auto fills until I validate the field?

This should help you:

http://www.filemaker.ws/help/html/edit_layout.10.26.html

For your #2 request, sounds like you need to script the record creation. You can do this by creating a single record in the match table, setting the match serial # as a variable (IE set variable $id = match::serial). Then go to the Rounds table, create two records, and assign a foreign key (IE set field round::parentKey - $id) to relate it to round.

You can execute this script via a button so that creates all three records and returns to the match form view.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.