buskyboy Posted February 1, 2011 Share Posted February 1, 2011 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 Link to comment Share on other sites More sharing options...
comment Posted February 1, 2011 Share Posted February 1, 2011 I was able to go to a layout of the contract On which table is this layout based? If you have a standard contract, with only the name of the artist and the job details to fill out, then the layout should be based on the Talent_lines table. Link to comment Share on other sites More sharing options...
buskyboy Posted February 1, 2011 Author Share Posted February 1, 2011 On which table is this layout based? If you have a standard contract, with only the name of the artist and the job details to fill out, then the layout should be based on the Talent_lines table. 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 Link to comment Share on other sites More sharing options...
comment Posted February 1, 2011 Share Posted February 1, 2011 Your file requires a password. the layout is based on the jobs table as there are many variables for each job That's not a good enough reason. By the very nature of the join table, there is only one related job record for each join - so the correct job details will be pulled from the Jobs table. OTOH, a job has many related records in the join table, so the artist details will be pulled from the first related record in Artists. Link to comment Share on other sites More sharing options...
buskyboy Posted February 1, 2011 Author Share Posted February 1, 2011 Your file requires a password. That's not a good enough reason. By the very nature of the join table, there is only one related job record for each join - so the correct job details will be pulled from the Jobs table. OTOH, a job has many related records in the join table, so the artist details will be pulled from the first related record in Artists. 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. Link to comment Share on other sites More sharing options...
comment Posted February 1, 2011 Share Posted February 1, 2011 Have a look at the 'Print Artist Contract' layout. application.zip Link to comment Share on other sites More sharing options...
buskyboy Posted February 1, 2011 Author Share Posted February 1, 2011 Have a look at the 'Print Artist Contract' layout. 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4833 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now