Jump to content
Sign in to follow this  
Gogargirl

Related fields or scripts?

Recommended Posts

crazy.gif" border="0 I'm one of the many who think Filemaker is great precisely because you don't need to be a techie to create a dbase. But there comes a time when you know what the task is, but you can't work out the best approach....

I have a dbase with around 800-1000 records, representing people. There are 100 subsets of up to 10 records which are not constant, i.e. a person can be moved from one subset to another. From time to time, I want to view a specific subset (in form, not list, format) and to see at the same time on the layout 3 fields of information specific to each person.

All this is easy to do either with 10 relationships and 30 related fields on the layout, or with a script which finds the required subset and loops through it copying and pasting the data into 30 global fields.

But which is the best way to do it? Does one or other method work faster / make the file bigger / use more system resources?

Grateful for your thoughts!

Share this post


Link to post
Share on other sites

I was following you up to "All this is easy to do". To associate groups of people, I'm not sure why you would need 10 relationships and 30 fields.

If you have a field "Group", one relationship based upon a global field with a value list will allow you to select which subset is displayed in a portal. To move someone to another group, all you need to do is change the value of the Group field for that person on the portal line, refresh the layout, and they will vanish from the currently displayed group in the portal.

-bd

Share this post


Link to post
Share on other sites

.....and I follow you completely, thanks.

What I forgot to mention (oops!) is that the related records of names need to be displayed in a circle, like round a clock. Each person's unique data (job title, firm and category) has to appear under their name.

Can't do this with portals, can I?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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