Passing values from one form1 to form2, then using query to generate report

[mackmaru]

Hi there
I haven't touched Access 2007 for a long time. This situation is this.
Client Form (Form1) has a button that goes to Jobs Form (Form 2) - This is a one to many relationship.
When creating a new job I pull data from Form 1 using Properties\Data\... to pull data from each field I want to show on Form2 eg, PK ID, Full Name, Address, and specifically a YES/NO box used when job is completed.
This uses =[Forms]![Form1]![PKID], which works fine. However when I create a query to find all jobs that are "YES" or "NO", all fields that use =[Forms]![Form1]![PKID] etc do not show on the report.
I dont know why. Please help. ( The values are not being saved in those fields)

Regards

[Minty]

Firstly if you record the PK of the master table there is no need to record anything else in the child table that relates to it, unless that data might change and it's important you capture it at that time.
Static data such as Full Name etc shouldn't be recorded again in the job table. You are duplicating data for no reason.

Secondly - the Yes No box - if it's important why aren't you storing the data?
Do you have a Completion date ? if so the Yes / No is redundant ?

For a report the data has to be in the queries underlying data, so either store it or calculate it.

It might help to show your tables and the relationships , in case I've got the wrong end of the stick?

[mackmaru]

I think I understand what you're saying about duplicating data. Let me get back to it and I'll let you know. Cheers.

[mackmaru]

HI there, Thank you so much, that helps. I was over thinking and wanting too much data on my forms/reports. Thank you again.

[Minty]

No problem, sometime wood from the trees sets in. I know it still does with my work.

You can always display related data, just don't need to store it.

Good luck with your project.