Bashing My Head Against A Brick Wall!!

[frommy]

Hi all,

I've been working with FMP 8.5 on the free trial, and am nearly finished creating a Guest List database for an upcoming tour I'm doing. The problem I have is getting the report to look the way I want.

I want to get the number of tickets, guest passes, backstage passes etc... for each show listed per show, and per person. This works OK, but then I try to bring a related table in as each person that has tickets can have up to 10 guests which need to appear on the list. This is what I want...

23 Sep 06 Barcelona SanJordi

Joe Bloggs (no. Tix) (no. Guests) (no. VIPs) (no. Aftershow)

• Mary Bloggs (no. Tix) (no. Guests) (no. VIPs) (no. Aftershow)
  
• Baby Bloggs (no. Tix) (no. Guests) (no. VIPs) (no. Aftershow)
  
• Babe Bloggs (no. Tix) (no. Guests) (no. VIPs) (no. Aftershow)
  

Total Bloggs (no. Tix) (no. Guests) (no. VIPs) (no. Aftershow)

You get the idea. But I just can't get the related table's data into the report. All I get are blank edit boxes under the first name (and only ever one box per venue). I have set up the tables so that the original has an ID (generated by the computer) and related that to the 'Invited by' field in the second table which is a calculation field "list (First Name) & " " & (Second Name)" from the original table.

Can anyone spot what I'm doing wrong?

Extra points if you can work out what show I'm working on!!

Thanks in advance

Frommy (confused in Brighton, UK)

[Fitch]

You're relating a serial number to a name? That won't work. The two sides of the relationship have to match.

[frommy]

Brilliant, yes, that's fixed the problem. I now have a second problem - the report is only finding the first related record instead of the nice list I was expecting under the name. Any ideas guys?

[Genx]

You have to report from the "Many" side of the relationship.

[frommy]

I see. I've tried that, and now I can only get the names with additional guests to print. Not the ones with no guests. Sorry, I'll leave you all alone soon!

[Fitch]

It sounds like you would have to report from the "One" side of the relationship after all. Most of the time we avoid reports with portals because there have been some quirks in the past with printing, but they actually work fairly well. Put a portal to the related file under the main name, and set the portal to slide up (under Format>Set Sliding/Printing).