New query will not show values in the popup form, 1

[Patentinv]

Hi,
I have a popup form called Labor that is working perfectly fine, what i mean is that it is getting populated with data from the query I built using a single table called PrimaryBid_Master. However I have had to add many fields to this table before invoking a query on it, now I'm running close to the 255 field max limitation.
So I have created a new table called Labor_Primary with all the fields that I need and took them out of the PrimaryBid_Master table freeing up about 50 fields.

The query I made combines 2 tables: table1=PrimaryBid_Master table2=Labor_Primary, they are linked by a common field called invoice#.
But now when I’m in the PrimaryBid_Master form and click the command button to go to the popup form Labor non of the values that were populating the popup form from the primaryBid_Master form work, they were working fine the only thing I changed was the popup forms record source to the new query I built.
Here is a print screen of the new query I built using 2 tables, and I also show the old query that works fine using 1 table.

http://www.roofmart.net/query1.asp

Maybe you can see some thing I did wrong; do I need some type of filter to fetch the fields? When I open the new query there is no data/values in it.

Thanks--I appreciate any help.

 

[jsteph]

First, you may need to normalize the db, there are faqs on that here, but to get the immediate problem fixed, I need a clarification--is a one-to-one link between the tables what you want?

If so, judging by the query, the labor table's Invoice# is not a primary key, and it should be. And, though I can't see the actual field that it's linked to in the bid master, I have to assume it's Invoice#, and that should be primary key also.

But, when you get close to 255 fields in a table, it's often a red flag begging for normalization.
--Jim

 

[jsteph]

...to add to my response--check that there are indeed values that exist in Labor table based on Invoice#--it doesn't *need* to be a Primary Key to get the values to show, but I got tied up on that tangent looking at the query screenshot.
--Jim