Y
Yula
I have a form which is based on a query that is joining several tables all
related by a primary key "Tracking Number". I am using that query "Test2" as
the control source for my form " form2". I got the form to add records and
its working just fine, when I go into the query, those records that I added
are not showing up in that Test2. In fact, i can't even add a record in the
datasheet view of the query. I am posting the SQL for Test2 and I would
appreciate all the help I could get.
Thanks!
Yula
SELECT [Customer Table].[Tracking Number], [Customer Table].[Network Login
ID], [Customer Table].[Submitted By], [Customer Table].[Delivery Building],
[Customer Table].[Delivery Floor], [Customer Table].[Cost Center], [Customer
Table].BU, [Customer Table].Telephone, [Customer Table].Department, [Customer
Table].Division, [Date Table].[Time Submitted], [Finish Table].[Type of
Finish], [Impressions Table].Machine, [Impressions Table].[Black_White or
Color], [Date Table].[Date Required], [Paper Table].Paper,
Quantities.[Impressions Per Original], Quantities.[1 or 2 sided], [Date
Table].[Time Required], [Date Table].[Date Completed], [Date Table].[Time
Completed], [Date Table].[Date Submitted], Quantities.[Start Meter],
Quantities.[End Meter], Quantities.[File Type], Size.[Width IN], Size.[Length
IN], Quantities.[Total Copies Requested], [Operator Table].Operator
FROM [Paper Lookup] INNER JOIN ([Machine Lookup] INNER JOIN ([Finish Lookup]
INNER JOIN (((((([Finish Table] INNER JOIN ([Customer Table] INNER JOIN
Quantities ON [Customer Table].[Tracking Number] = Quantities.[Tracking
Number]) ON [Finish Table].[Tracking Number] = [Customer Table].[Tracking
Number]) INNER JOIN [Impressions Table] ON [Customer Table].[Tracking Number]
= [Impressions Table].[Tracking Number]) INNER JOIN [Operator Table] ON
[Customer Table].[Tracking Number] = [Operator Table].[Tracking Number])
INNER JOIN [Paper Table] ON [Customer Table].[Tracking Number] = [Paper
Table].[Tracking Number]) INNER JOIN [Date Table] ON [Customer
Table].[Tracking Number] = [Date Table].[Tracking Number]) INNER JOIN [Size]
ON ([Finish Table].[Tracking Number] = Size.[Tracking Number]) AND ([Paper
Table].[Tracking Number] = Size.[Tracking Number]) AND ([Customer
Table].[Tracking Number] = Size.[Tracking Number]) AND ([Paper
Table].[Tracking Number] = Size.[Tracking Number]) AND ([Customer
Table].[Tracking Number] = Size.[Tracking Number]) AND (Quantities.[Tracking
Number] = Size.[Tracking Number])) ON [Finish Lookup].[Finish Description] =
[Finish Table].[Type of Finish]) ON [Machine Lookup].[Machine Name] =
[Impressions Table].Machine) ON [Paper Lookup].[Paper Description] = [Paper
Table].Paper;
related by a primary key "Tracking Number". I am using that query "Test2" as
the control source for my form " form2". I got the form to add records and
its working just fine, when I go into the query, those records that I added
are not showing up in that Test2. In fact, i can't even add a record in the
datasheet view of the query. I am posting the SQL for Test2 and I would
appreciate all the help I could get.
Thanks!
Yula
SELECT [Customer Table].[Tracking Number], [Customer Table].[Network Login
ID], [Customer Table].[Submitted By], [Customer Table].[Delivery Building],
[Customer Table].[Delivery Floor], [Customer Table].[Cost Center], [Customer
Table].BU, [Customer Table].Telephone, [Customer Table].Department, [Customer
Table].Division, [Date Table].[Time Submitted], [Finish Table].[Type of
Finish], [Impressions Table].Machine, [Impressions Table].[Black_White or
Color], [Date Table].[Date Required], [Paper Table].Paper,
Quantities.[Impressions Per Original], Quantities.[1 or 2 sided], [Date
Table].[Time Required], [Date Table].[Date Completed], [Date Table].[Time
Completed], [Date Table].[Date Submitted], Quantities.[Start Meter],
Quantities.[End Meter], Quantities.[File Type], Size.[Width IN], Size.[Length
IN], Quantities.[Total Copies Requested], [Operator Table].Operator
FROM [Paper Lookup] INNER JOIN ([Machine Lookup] INNER JOIN ([Finish Lookup]
INNER JOIN (((((([Finish Table] INNER JOIN ([Customer Table] INNER JOIN
Quantities ON [Customer Table].[Tracking Number] = Quantities.[Tracking
Number]) ON [Finish Table].[Tracking Number] = [Customer Table].[Tracking
Number]) INNER JOIN [Impressions Table] ON [Customer Table].[Tracking Number]
= [Impressions Table].[Tracking Number]) INNER JOIN [Operator Table] ON
[Customer Table].[Tracking Number] = [Operator Table].[Tracking Number])
INNER JOIN [Paper Table] ON [Customer Table].[Tracking Number] = [Paper
Table].[Tracking Number]) INNER JOIN [Date Table] ON [Customer
Table].[Tracking Number] = [Date Table].[Tracking Number]) INNER JOIN [Size]
ON ([Finish Table].[Tracking Number] = Size.[Tracking Number]) AND ([Paper
Table].[Tracking Number] = Size.[Tracking Number]) AND ([Customer
Table].[Tracking Number] = Size.[Tracking Number]) AND ([Paper
Table].[Tracking Number] = Size.[Tracking Number]) AND ([Customer
Table].[Tracking Number] = Size.[Tracking Number]) AND (Quantities.[Tracking
Number] = Size.[Tracking Number])) ON [Finish Lookup].[Finish Description] =
[Finish Table].[Type of Finish]) ON [Machine Lookup].[Machine Name] =
[Impressions Table].Machine) ON [Paper Lookup].[Paper Description] = [Paper
Table].Paper;