Form does not show previously entered records
From: Kevin Sprinkel (anonymous_at_discussions.microsoft.com)
Date: 03/23/04
- Next message: Tarek: "Can Grow property"
- Previous message: Michel Walsh: "Re: Retiring one field when another is filled"
- In reply to: Kevin Sprinkel: "Form does not show previously entered records"
- Next in thread: John Vinson: "Re: Form does not show previously entered records"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Mar 2004 05:28:02 -0800
In analyzing this query last night, it seems that TBL -
Aircraft is your basic table, and all others are either in
a one-to-one or one-to-many relationship with them, joined
by the registration number. In either case, I agree with
John's suggested approach of using subforms. Divide and
conquer!
Create a form for each of the "subtables" based either on
the table itself or a simple query. Include the linking
field, Registration No in a query, but do not include a
control for it on your form. Insert each on a main form
based on TBL - Aircraft, and set the Link Master Fields
and Link Childs Fields to TBL - Aircraft.Registration No
and TBL - <subtablename>.Registration No, respectively.
Now, when you enter the registration number for the
aircraft, it will be entered into all the subtables.
Good luck, and let us know if you resolve your problem.
HTH
Kevin Sprinkel
----Original Message-----
>Ga Zoinks!!!
>
>This one may be beyond my current skill level, but I'll
>look at it on the train home tonight. In the meantime, I
>suspect that your form is not populating all the tables
>that you think it is. Your SQL statement has eight INNER
>JOIN statements. I would first look at both sides of
>those. If data isn't in both tables on either side of
the
>join, the record won't show up.
>
>And, BTW, as a former Product Manager at ITW Magnaflux,
>manufacturer of non-destructive testing materials and
>equipment used at original component manufacturer and
>during your overhauls, thanks for allowing me a glance
>back into your world.
>
>HTH
>Kevin Sprinkel
>
>>-----Original Message-----
>>The form is 3 tabs comprising fields from 10 different
>>tables. Here is the Record Source Property. It is very
>>lenghty. (I tried using a query, but then the form did
>not
>>populate the tables.)
>>
>>SELECT [TBL - Aircraft].Type, [TBL - Aircraft].
>>[Registration No] AS [TBL - Aircraft_Registration No],
>>[TBL - Aircraft].Make AS [TBL-Aircraft_Make], [TBL -
>>Aircraft].Model AS [TBL-Aircraft_Model], [TBL -
Aircraft].
>>[Airframe ID], [TBL - Aircraft].Year, [TBL - Aircraft].
>>[Operational Category], [TBL - Aircraft].[Ownership
>>Category], [TBL - Aircraft].[Acquisition Value], [TBL -
>>Aircraft].[Acquisition Date], [TBL - Aircraft].[Disposal
>>Date], [TBL - Aircraft].[Certificate of Airworthiness],
>>[TBL - Aircraft].[Certificate Date], [TBL - Aircraft].
[WS
>>Aircraft Inspection Date], [TBL - Aircraft].[WS Aircraft
>>Inspection Date Due], [TBL - Aircraft].[Weight Empty],
>>[TBL - Aircraft].[Weight & Balance Date], [TBL -
>Aircraft].
>>[Weight & Balance Due], [TBL - Aircraft].Location AS
[TBL-
>>Aircraft_Location], [TBL - Airframe FW].[Registration
No]
>>AS [TBL - Airframe FW_Registration No], [TBL - Airframe
>>FW].[Airframe Serial No:], [TBL - Airframe FW].[Total
>>Time:], [TBL - Airframe FW].[Time Since Rebuild:], [TBL -
>>Airframe FW].[Date of Rebuild:], [TBL - Airframe FW].
>>[Extended Wings], [TBL - Airframe FW].[Extended
Aileron],
>>[TBL - Airframe FW].[Extended Flaps], [TBL - Airframe
FW].
>>[Extended Landing Gear], [TBL - Airframe FW].[Extended
>Sky
>>Light], [TBL - Airframe FW].[Fuel Tank Size], [TBL -
ELT].
>>[Registration No] AS [TBL - ELT_Registration No], [TBL -
>>ELT].[ELT Serial No], [TBL - ELT].Make AS [TBL-
ELT_Make],
>>[TBL - ELT].Model AS [TBL-ELT_Model], [TBL - ELT].
>[Battery
>>Date], [TBL - ELT].Location AS [TBL-ELT_Location], [TBL -
>>GPS].[Registration No] AS [TBL - GPS_Registration No],
>>[TBL - GPS].[GPS Serial No], [TBL - GPS].Make AS [TBL-
>>GPS_Make], [TBL - GPS].Model AS [TBL-GPS_Model], [TBL -
>>Intercom].[Registration No] AS [TBL -
>>Intercom_Registration No], [TBL - Intercom].[Intercom
>>Serial No], [TBL - Intercom].Make AS [TBL-
Intercom_Make],
>>[TBL - Intercom].Model AS [TBL-Intercom_Model], [TBL -
>>NAVCOM].[Registration No] AS [TBL - NAVCOM_Registration
>>No], [TBL - NAVCOM].[NAVCOM Serial No], [TBL -
>>NAVCOM].Make AS [TBL-NAVCOM_Make], [TBL - NAVCOM].Model
>AS
>>[TBL-NAVCOM_Model], [TBL - Propeller FW].[Registration
>No]
>>AS [TBL - Propeller FW_Registration No], [TBL -
Propeller
>>FW].Make AS [TBL - Propeller FW_Make], [TBL - Propeller
>>FW].Model AS [TBL - Propeller FW_Model], [TBL -
Propeller
>>FW].[Propeller Serial No], [TBL - Propeller FW].[Total
>>Time] AS [TBL - Propeller FW_Total Time], [TBL -
>Propeller
>>FW].[Time SMOH] AS [TBL - Propeller FW_Time SMOH], [TBL -
>>Propeller FW].[Date of Major Overhaul] AS [TBL -
>Propeller
>>FW_Date of Major Overhaul], [TBL - ServiceRadio].
>>[Registration No] AS [TBL - ServiceRadio_Registration
>No],
>>[TBL - ServiceRadio].[Service Radio Serial No], [TBL -
>>ServiceRadio].Make AS [TBL-ServiceRadio_Make], [TBL -
>>ServiceRadio].Model AS [TBL-ServiceRadio_Model], [TBL -
>>Transponder].[Registration No] AS [TBL -
>>Transponder_Registration No], [TBL - Transponder].
>>[Transponder Serial No], [TBL - Transponder].Make AS
[TBL-
>>Transponder_Make], [TBL - Transponder].Model AS [TBL-
>>Transponder_Model], [TBL Engine FW].[Registration No] AS
>>[TBL Engine FW_Registration No], [TBL Engine FW].Make AS
>>[TBL Engine FW_Make], [TBL Engine FW].Model AS [TBL
>Engine
>>FW_Model], [TBL Engine FW].[Engine Serial No], [TBL
>Engine
>>FW].Horsepower, [TBL Engine FW].[Total Time] AS [TBL
>>Engine FW_Total Time], [TBL Engine FW].[Time SMOH] AS
>[TBL
>>Engine FW_Time SMOH], [TBL Engine FW].[Date of Major
>>Overhaul] AS [TBL Engine FW_Date of Major Overhaul] FROM
>>(((((((([TBL - Aircraft] INNER JOIN [TBL - ELT] ON [TBL -
>>Aircraft].[Registration No]=[TBL - ELT].[Registration
>No])
>>INNER JOIN [TBL - GPS] ON [TBL - Aircraft].[Registration
>>No]=[TBL - GPS].[Registration No]) INNER JOIN [TBL -
>>Intercom] ON [TBL - Aircraft].[Registration No]=[TBL -
>>Intercom].[Registration No]) INNER JOIN [TBL - NAVCOM]
ON
>>[TBL - Aircraft].[Registration No]=[TBL - NAVCOM].
>>[Registration No]) INNER JOIN [TBL - Propeller FW] ON
>>[TBL - Aircraft].[Registration No]=[TBL - Propeller FW].
>>[Registration No]) INNER JOIN [TBL - ServiceRadio] ON
>>[TBL - Aircraft].[Registration No]=[TBL - ServiceRadio].
>>[Registration No]) INNER JOIN [TBL - Transponder] ON
>[TBL -
>> Aircraft].[Registration No]=[TBL - Transponder].
>>[Registration No]) INNER JOIN [TBL Engine FW] ON [TBL -
>>Aircraft].[Registration No]=[TBL Engine FW].
[Registration
>>No]) INNER JOIN [TBL - Airframe FW] ON [TBL - Aircraft].
>>[Registration No]=[TBL - Airframe FW].[Registration No];
>>>-----Original Message-----
>>>Bobbi,
>>>
>>>A form's Record Source may only be a single table or
>>>query. The query may include fields from multiple
>tables.
>>>
>>>Please post the value in the form's Record Source
>>>property. I suspect this will be the name of a saved
>>>query or an SQL statement. If so, please post the SQL.
>>>
>>>If this is not the root of your problem, please provide
>>>additional detail about the form.
>>>
>>>Kevin
>>>
>>>>-----Original Message-----
>>>>It is not based on a query but on multiple tables.
>>>>Bobbi
>>>>>-----Original Message-----
>>>>>Is it possible that your form's Record Source is a
>>query
>>>>>that has selection criteria set such that it doesn't
>>>>>select the new records?
>>>>>
>>>>>HTH
>>>>>Kevin Sprinkel
>>>
>>>.
>>>
>>.
>>
>.
>
- Next message: Tarek: "Can Grow property"
- Previous message: Michel Walsh: "Re: Retiring one field when another is filled"
- In reply to: Kevin Sprinkel: "Form does not show previously entered records"
- Next in thread: John Vinson: "Re: Form does not show previously entered records"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
