Jump to content

Create a Portal from Four different Table/Layouts


Recommended Posts

  • Newbies

Hello!

I have a file where one of the features is to create (or import) spot cues. I have up to four spots in the file that can be recorded, and all are on separate tables. I would like to be able to have all of them shown on one layout as well so I can see all my spot cues at once. obviously I figured out how to do that individually, but now I want more. 

Recap, the four spots cue records have to be on their own table so their records don't mix together. I know I would need a relationship (I tried and didn't get much out of it.) then put each spot in a total on one layout. 

Each spot has at least 10 field (they're the same) but for each cue they could be different depending on the cue.

Im super sorry if this confusing you. Please feel free to leave comments! I have many more questions, so if you are up for them please PM me or comment below! Thank you and stay safe everyone!

Screen Shot 2020-04-06 at 7.09.25 PM.png

Link to post
Share on other sites

A portal shows a row for each related record from a single table. 

If each spot has the same fields, then it makes no sense to put them in different tables. If they are of different types, add a type field to the table.

 

Edited by comment
Link to post
Share on other sites
  • Newbies

each spot will have the same field type but different things inside. Spot 1 thru 4 could have one cue the same and another different. 

seeing all at once is so I can manage all on one screen after i created them all and or print like a 'master version'. 

Link to post
Share on other sites

It doesn't sound like you have your table structure correct.  Judging by the nouns then "spots" would be one table and "spot cues" would be a second table.  You would not have 4 different tables, one for each spot.  A spot should just be a record in a 'spots' table.

With this structure you would be able to see as many spots on one layout as you want to see.

Link to post
Share on other sites
  • Newbies

So with your comment, I can see each spot's cue whether they are the same or not?  As I am still new to this program, can you maybe explain that more in detail?  

 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

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