I have a database that relates to another database that contains 5 competitors and their monthly spending.

Each competitor has their own record in the other database and their names are contained in the same field.

I want to be able to bring each competitors spend into a single record on a TAB layout and show each comeptitors spend.

I can bring in one competitors spend but am having a brain freeze on how to get the other brands in.

Any thoughts? Am I being to vague?

Thanks

Any chance you can make a mock-up file?

Sorry I didn't attach my files to the original post and couldn't figure out how to attach them so I created a new post.

Attached are my sample files.

I basically want to pull in Brand and TRPs into the Parent file onto the same record.

What's the best way to accomplish this?

Thanks for any help.

Patrick

FM_Example.zip

And what do you mean by a Tab layout, in FileMaker 7? In FileMaker 8 you could do the above using the Tab object. In 7 or 8 you could do layouts. Basically, if there are not more than 5 you could just show the 1st row of a portal based on the relationship (start row 1, show 1 row), then on the next "tab" start 2nd row, show 1, next start row 3, show 1, etc..

Actually, in 7 I think I'd just use a global field to hold the originating side of the relationship key, then flip it to each of the different 5 (or however many) competitors with a button.* I wouldn't create multiple layouts, 'cause it's a pain to update 5 nearly identical layouts.

The multiple keys could be gotten from ValueListItems (Get(FileName), "value list based on portal relationship"). You would then parse out the lines one at a time, with a global counter to get line 1, line 2, etc.. Of course incrementing the counter is also easier in 8, with the GetValue() function, but MiddleValues() will work in 7. Or in 8, it would be simpler to use GetNthRecord(portal relationship, 1), etc..

*Or a little row of buttons, in a portal based on the relationship. That way you'd only have a button if there was a related record at that position. In FileMaker 8, if you used Tabs, it would be a bit tricky to only show a tab if there was a related record, but it could be done.

Sorry Fenton,

I haven't updated my personal info. I am on FM 8.5 Advanced.

I have added another post with sample files of what I am trying to do.

Thanks for your help.

Patrick

OK. I figured this out. A simple portal worked...a little slow this week.