Unable to figure it out!

[dcbug]

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]

[Lee Smith]

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

[Vaughan]

"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.

[dcbug]

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???

[dcbug]

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!

[Lee Smith]

save a clone, no records.

[dcbug]

I just want to thank you all for being there to help people when they run into brick walls. :

[dcbug]

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.

[dcbug]

Okay, just figured out how to get the zip uploaded, duh!

Relationships.fp7.zip

Edited May 15, 2007 by Guest

[dcbug]

Cloning the file has lost all key fields and relationships.

Can anyone make head or tails of the file?