SC Table relationships for dummies?

[MariaAux]

Hi There,

I've got my brand new SC under the bonnet and ready to take it for a spin. I have read throoughly through the manual and there is something I am simply not grasping.

I have two tables

1. A list of 500 images / worksheets in a container field with a text field identical to the Name of the Game they were for

2. A list of 500 Children's games

Previously, I related the the GameName field in the Images/Worksheets table with the Name of the Game in the Games Table, all worked fine except for IWP slowness due to native container fields.

But how does one relate a Web Viewer with another table?

And while I am at it, one more quick question. Does every file within the Supercontainer file directory have to have it's own folder i.e. one file in each designated folder? Or can many files all be in one folder?

Thanks so much,

Maria

[bcooney]

The webviewer is your container field, it doesn't relate. You would still have the game name in a text field related to the game record. Of course, I would use record IDs instead of a game name.

Yes, SC creates a folder for each webviewer.

[ooparah]

MariaAux---

For an example on using related tables with SuperContainer/Portals/Container fields, you can give our example database file a look, by visiting the following link.

I hope this helps,