dcbug Posted May 15, 2007 Share Posted May 15, 2007 Hello All, I have many jobs which have many details to them. I would like to enter an invoice from a vendor for a job and choose which details I want to apply to the invoice. The details reside in a line items file while the job code is in the master file. I can't seem to get the relationships to correctly pull up the details of the job. I get the details of all the jobs rather than the one job I choose. I would like to choose the details of the job from a value list, but again, I can't get the value list to just show the details of a particular job. I've been struggling with many to many, three way, etc. and conditional value lists but no go. Thanks! : [color:red] Link to comment Share on other sites More sharing options...
Lee Smith Posted May 15, 2007 Share Posted May 15, 2007 Hi, Deb, Why not attach a copy of your files so that we don't have to ask for the field names, relationships, file names, etc. Lee Link to comment Share on other sites More sharing options...
Vaughan Posted May 15, 2007 Share Posted May 15, 2007 "The details reside in a line items file..." That's probably your problem. The details need to be in the Jobs table. "... while the job code is in the master file." I'm not sure what you mean by "master" file: is it vendor, invoice, or job? It sounds like you've got data all over the place. Link to comment Share on other sites More sharing options...
dcbug Posted May 15, 2007 Author Share Posted May 15, 2007 Hi There, The Jobs TO is the master data for all the jobs (after being transferred from Estimates). From the Jobs TO all activity begins, material is ordered(PO's), labor is applied(Payroll), Invoices(AP), and Billings(AR) yadi yada. I kept the same structure from the Estimates TO, using a line items file allowed me to select specific Details. Maybe I don't really need it in the Jobs file??? Link to comment Share on other sites More sharing options...
dcbug Posted May 15, 2007 Author Share Posted May 15, 2007 I'd love to but it's about 20mb all in one file. I suppose I could export just the TO's I'm talking about. Give me a few! Link to comment Share on other sites More sharing options...
Lee Smith Posted May 15, 2007 Share Posted May 15, 2007 save a clone, no records. Link to comment Share on other sites More sharing options...
dcbug Posted May 15, 2007 Author Share Posted May 15, 2007 I just want to thank you all for being there to help people when they run into brick walls. : Link to comment Share on other sites More sharing options...
dcbug Posted May 15, 2007 Author Share Posted May 15, 2007 Even the clone with no reordss was 10mb but here goes a paired down version. I didn't realize I can't post .FP7 extensions so here are some .pngs. Link to comment Share on other sites More sharing options...
dcbug Posted May 15, 2007 Author Share Posted May 15, 2007 (edited) Okay, just figured out how to get the zip uploaded, duh! Relationships.fp7.zip Edited May 15, 2007 by Guest Link to comment Share on other sites More sharing options...
dcbug Posted May 15, 2007 Author Share Posted May 15, 2007 Cloning the file has lost all key fields and relationships. Can anyone make head or tails of the file? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6191 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