I have read several books on Access, over the years, and have not found any specific guidance to this point.
Accepting that one knows about designing tables, normalisation and building forms, should one always use the respective
table when setting the control source for its main form? Take, for example, a table named tblClients and a form named frmClients
which shows all fields from tblClient, if I want to show fields from another table (assuming they have an established
relationship) then the fields from table2 do not show in the tblClients control source drop down list.
It would be anti normalisation practice to include fields from table2 in tblClients field list (apart from say tbl2.fieldID, and the only way I
can see to incorporate the tbl2 fields into tblClients is to make a query which has all the fields from tblClients and those I want from table2.
Is this how one should produce the control source for tblClients by making a query i.e. qry Clients?
Regards
Cheyanne