buskyboy

It worked a treat. Thank you :)

I cannot think of a solution to this problem. I have some related records in a portal. I want for example to get all the suppliers names form a column and make them into a single text field to display in a merge field on another layout. I'm sure this is possible and probably easy but I cannot think of a solution. Any help would be appreciated. :mellow: Cheers Patrick

You know i tried that but must have done something wrong. I now a get a letter for each row. Thank you. I assume I can now just add a script to a button in the portal row which will restrict it to one contract. Thank you very much for your help. Your very kind Cheers Patrick

sorry username sue password sue not sure what you mean. I thought that I would be able to get all the details from the job table for the related row in the talent_line table but not so.

thanks for your reply the layout is based on the jobs table as there are many variables for each job eg times venues etc I have attached a clone of the file for you if that helps. I do appreciate this application.fp7.zip

Hello Everyone, This is my first posting and I need help. I think there is probably a simple explanation for my problem. Here goes... I am making a database for an entertainment agency. I have 4 main tables ( Customers, Talent, Talent_lines, Jobs) Relationships : Customers > jobs (1 to Many) Jobs > Talent_lines (1 to Many) this is a join table as a single job can use many artists. Talent > Talent_lines (1 to many) The Problem. Most things are going well.. I have a portal in Jobs (form layout) showing the talent that is booked for the job. I am trying to print a contract for each artist(talent). When I originally set up the database I only had it working with one 1 artist per job and I was able to go to a layout of the contract and fill in all the details from the jobs and related tables. After adding the join table I can only manage to get it to fill out a contact for the first row of the portal. I would love to be able to put a button on each portal row and then go to a print contract layout form each record in the portal. After 2 days of trying things I'm stuck and hence need your help. I hope this email makes sense, if you need more info just let me know Cheers Patrick