selecting records in a portal (line items)

[birchtree]

Hello

I have 3 tables. Event, Sponsors & Banners. In other words the Sponsors advertise in various Events with their Banners.

Each Sponser has many Banners and this is easy to show all the Banners for each Sponsor with a portal. Each Event has many Banners but I want to pick the banners through a portal like line items on a product invoice. The Banners are essentially inventory items for an Event. To recap - both Sponsors-Banners and Events-Banners are 1-to-many but in the former I want to show all the Banners for each Sponsor and in the latter case I want to pick which Banner is displayed in various Events. I should also mention I want to copy each Banner into each Event si it is permanent. Sorry if I sound a little confused but I must confess I actually am confused.

Thanks

Ken

[Ocean West]

confusion is good, at least your half way there!

How about a Multi key index.

In the banner file create a text field,

Then through scripts or manual entry populate that field with

the unique event ID that it is apart of, seperated by return.

E100

[birchtree]

quote:

---

Originally posted by Ocean West:

confusion is good, at least your half way there!

How about a Multi key index.

In the banner file create a text field,

Then through scripts or manual entry populate that field with

the unique event ID that it is apart of, seperated by return.

E100

[mitchn]

Ocean West

I was browsing the forum and noticed your solution to this riddle...

never knew it existed and I love it. WORKS GREAT

Thanks