Silvia Posted February 7, 2002 Share Posted February 7, 2002 I'm creating a database in FileMaker Pro 5 that will be used for a web site. I have never done a database in FM before (only worked a little with Access), so I hope someone here can help me out a little. I've come as far as creating several database files (one master file and 3 related files). So far so good (I think, lol). The database is supposed to display projects by an architect firm and so I've created the following database files: - projects.fp5 - employer.fp5 - category.fp5 - images.fp5 In projects.fp5 I've entered information on some of the projects in order to have something to test with. I've also entered test information in employer.fp5 and catefory.fp5. The big problem is that I don't know how to display images for each project. Each project should be able to display up to 6 images. I thought the best way to do this was to have all images in a seperate database file (images.fp5). So how do I display the correct images to each project on the correct project? I don't think I can do it in the Lay-Out mode, 'cause then I'd be displaying the same images throughout all of the projects - and that's not what I want. Can anyone help me out a little? I'd be VERY grateful! Thanks!! Quote Link to comment Share on other sites More sharing options...
blackcat Posted February 7, 2002 Share Posted February 7, 2002 I would use a portal in your project file which is linked to the images file via a relationship. You can show as many as you want then. In the portal row include the container of the images. To show an image at full size attach a script that switches layout to the select record. Steve Quote Link to comment Share on other sites More sharing options...
Silvia Posted February 7, 2002 Author Share Posted February 7, 2002 This is what I have done now: In the image database I made a record for each project with the possibility to display up to 6 images. I then linked the image database to the project database through "project ID". This works fine for the first project, but when I wanted to add images to the 2nd project in the images database it wouldn't display the project ID from the project database.. Hmmm.. What's a portal? (I'm quite green here) Is that what I do when I put fields from a related database into the master file? Quote Link to comment Share on other sites More sharing options...
hairyjim Posted February 7, 2002 Share Posted February 7, 2002 When you setup the relationship did you specify 'allow creation of related records' Quote Link to comment Share on other sites More sharing options...
Silvia Posted February 7, 2002 Author Share Posted February 7, 2002 No I didn't.. but what is that for? Isn't that what you do when you define a relationship?! Is it necessary? Quote Link to comment Share on other sites More sharing options...
Silvia Posted February 12, 2002 Author Share Posted February 12, 2002 I tried that now and it works. I still have a lot to learn... (I only started on FM5 last week). Thanks for the tip! Quote Link to comment Share on other sites More sharing options...
Silvia Posted February 12, 2002 Author Share Posted February 12, 2002 I tried that now and it works. I still have a lot to learn... (I only started on FM5 last week). Thanks for the tip! Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.