Layout made of existing Joins?

[gsprague]

Hello All,

I have a layout with a portal consisting of a client_application_join; a list of applictions per client. Is it possible to get all of my application lists of every client into another layout?

Thanks,

Galen

[transpower]

I'm not clear about your database architecture; you should have three tables: clients, applications, and join (client-application). Your applications table can be displayed in table view. Or just display the join table, sorted by client, in table view.

[gsprague]

What I needed was a Go To Related Field; which is set up. I currently have three data bases: clients, applications, and client_application_join. In my applications table I have a serial number field and a seat field (seat is how many serials I have for that same serial number; ie - group serial). I need to find out what clients are associated with all of those seats of a particular application. So currently I have a button to display all of my clients associated with that serial number but it is displaying my whole client_application_join database. I only want the client(s) associated with that particular serial number. Any ideas?

[gsprague]

Oops!! My bad; I had a Go to Related Page; First. Deleted that from my script and it works fine now.

Thanks,

Galen