RE second query. Same issue.
Here is SQL for a query which should give you the texts.
Open a query design, select SQL view and paste in the SQL below.
Once it is saved you can open the query in Design view to see the tables involved.
Run the query and see your result.
Code:
SELECT tblDeposits.DepositID, tblDepositTypes.DepositType, tblPeriod.Period
FROM tblPeriod INNER JOIN (tblDepositTypes INNER JOIN tblDeposits ON
tblDepositTypes.DepositTypeID = tblDeposits.DepositTypeID_FK) ON
tblPeriod.PeriodID = tblDeposits.PeriodID_FK
WHERE (((tblDeposits.DepositTypeID_FK)=1));
Here is the basic part of query 3. Copy and paste into the query design "sql view". Then view in Query Design to see tables involved and "joins".
Code:
SELECT tblAssociatedGoods.AssociatedGoodsType, tblDeposits.AssociatedGoodsDetail, tblOsteoSex.OsteoSex
FROM (tblAssociatedGoods INNER JOIN
(tblDeposits INNER JOIN tblAssociatedGoodsLink ON
tblDeposits.DepositID = tblAssociatedGoodsLink.DepositID_FK) ON
tblAssociatedGoods.AssociatedGoodsID = tblAssociatedGoodsLink.AssociatedGoodsID_FK)
INNER JOIN (tblOsteoSex INNER JOIN tblOsteoInfo ON
tblOsteoSex.OsteoSexID = tblOsteoInfo.OsteoSexID_FK) ON
tblDeposits.DepositID = tblOsteoInfo.DepositID_FK;
Good luck.