Updateable querie

  • Thread starter Thread starter gg
  • Start date Start date
G

gg

I have two queries, both updateable. I would like to join them as a form
source, but they aren't updateable when joined. Main table is same for both
queries The fields in the each table joined to my main table are primary,
indexed, no duplicates. I am using Access 2007

The queries, much simplified as to field count are:

Query 1
SELECT TblBoatData.IDboat, TblPersonalData.LNAME, TblBoatData.BOAT_NAME,
TblBoatData.LOA
FROM TblBoatData LEFT JOIN TblPersonalData ON TblBoatData.Id =
TblPersonalData.ID;

Query 2:
SELECT TblBoatData.IDboat, TblBoatData.BOAT_NAME, [loa]*[profilef]*10 AS
Tester, TblBoatData.LOA, T_DW_ProfileFactor.profilef
FROM (TblBoatData LEFT JOIN T_DW_BallastFactor ON TblBoatData.BALAST_MOV =
T_DW_BallastFactor.IDballast) LEFT JOIN T_DW_ProfileFactor ON
TblBoatData.Profile = T_DW_ProfileFactor.IDprofile;

These are highly reduced versions in terms of field count of the real
queries, but structure is identical and they act exactly the same way as the
bigger real version. I would like to join them with TblBoatData.IDboat.
 
Your best bet would to make one of the queries the control source for the
form and the other query the control source for a subform.

Better yet may be to have TblBoatData as the source for the form and have
TblPersonalData and T_DW_BallastFactor each on their own subforms.
 
Thanks much-I will give it a try. I really have hard time knowing when a
query is updateable. Usuelly just make sure joins are on indexed unique
fields and hope for the best.

Jerry Whittle said:
Your best bet would to make one of the queries the control source for the
form and the other query the control source for a subform.

Better yet may be to have TblBoatData as the source for the form and have
TblPersonalData and T_DW_BallastFactor each on their own subforms.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


gg said:
I have two queries, both updateable. I would like to join them as a form
source, but they aren't updateable when joined. Main table is same for both
queries The fields in the each table joined to my main table are primary,
indexed, no duplicates. I am using Access 2007

The queries, much simplified as to field count are:

Query 1
SELECT TblBoatData.IDboat, TblPersonalData.LNAME, TblBoatData.BOAT_NAME,
TblBoatData.LOA
FROM TblBoatData LEFT JOIN TblPersonalData ON TblBoatData.Id =
TblPersonalData.ID;

Query 2:
SELECT TblBoatData.IDboat, TblBoatData.BOAT_NAME, [loa]*[profilef]*10 AS
Tester, TblBoatData.LOA, T_DW_ProfileFactor.profilef
FROM (TblBoatData LEFT JOIN T_DW_BallastFactor ON TblBoatData.BALAST_MOV =
T_DW_BallastFactor.IDballast) LEFT JOIN T_DW_ProfileFactor ON
TblBoatData.Profile = T_DW_ProfileFactor.IDprofile;

These are highly reduced versions in terms of field count of the real
queries, but structure is identical and they act exactly the same way as the
bigger real version. I would like to join them with TblBoatData.IDboat.
Click to expand...
Click to expand...
 
Back
Top