Jump to content
Sign in to follow this  
dcbug

Unable to figure it out!

Recommended Posts

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]

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

save a clone, no records.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Relationships.png

Layout.png

Share this post


Link to post
Share on other sites

Cloning the file has lost all key fields and relationships.

Can anyone make head or tails of the file?

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.