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.

Relationship Data between Layers

jelly0097
in Relational Database Theory

Featured Replies

  • Newbies

Hello! I apologize in advance for having this nonsense written. I am just lost and need help! 

I am trying to develop a 'small software' that can handle my lighting design information.  I am  trying to get relationships between multiple layers to correspond to each other. For example. 

I want to label Scene Titles in proper places for my Spot and Lighting Cues.  I have a scene management layout where I can designate where these scenes go however! I don't understand how to link it. 

Example.

Scene 1 is a Pre-Show Label on Light Cue 5 and Spot Cue 1. (Example Record for Cue is Record7 LIGHT CUE 5, and Spot Cue 1Record2 SPOT CUE 1

 So I tell that record line to export that label to the SPOT CUE 1 Layout page ( both of these are on different database tables) Scene Title Field. 

 

So my Scene Layout is like so

                   SceneSong:SceneTitle

Scene Num-Scene Title-SceneType-LXCUE-SPCUE

 

Then my Cue and Spot Cue Page looks similar. 

How can the Scene Title properly export its contents to the correct layout and record # based on either that record or a designated field. I would rather put what Cue # than Filemaker record 

 

I have files and screen shares of what I am doing. I appreciate any and all help. Please feel free to comment below and lets chat! 

Visit here for screen grabs of what I am saying. https://www.joelpmckenzie.com/follow

2 minutes ago, jelly0097 said:

Hello! I apologize in advance for having this nonsense written. I am just lost and need help! 

I am trying to develop a 'small software' that can handle my lighting design information.  I am  trying to get relationships between multiple layers to correspond to each other. For example. 

I want to label Scene Titles in proper places for my Spot and Lighting Cues.  I have a scene management layout where I can designate where these scenes go however! I don't understand how to link it. 

Example.

Scene 1 is a Pre-Show Label on Light Cue 5 and Spot Cue 1. (Example Record for Cue is Record7 LIGHT CUE 5, and Spot Cue 1Record2 SPOT CUE 1

 So I tell that record line to export that label to the SPOT CUE 1 Layout page ( both of these are on different database tables) Scene Title Field. 

 

So my Scene Layout is like so

                   SceneSong:SceneTitle

Scene Num-Scene Title-SceneType-LXCUE-SPCUE

 

Then my Cue and Spot Cue Page looks similar. 

How can the Scene Title properly export its contents to the correct layout and record # based on either that record or a designated field. I would rather put what Cue # than Filemaker record 

 

I have files and screen shares of what I am doing. I appreciate any and all help. Please feel free to comment below and lets chat! 

Visit here for screen grabs of what I am saying. https://www.joelpmckenzie.com/followme

 

Create an account or sign in to comment

https://fmforums.com/topic/106015-relationship-data-between-layers/
Go to topic listing

Important Information

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

I accept

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.