From frmEditSpecials I am referring to the two right hand cloumns. Very occasionally these may need to change. e.g. a new group may need to be added at any position in the column.If this happens all numbers must be adjusted to end of list. In tblSpecialistBodyNotes column 1(SchedHeadingNbr) matches same field in frmEditSpecials. Column 3 (Headings) just the Specialist Bodies are listed e.g. Yorkshire, Norwich, Border etc and these are aligned with their respective SchedHeadingNbr. The rptSchedule is derived from tblSpecials and tblSpecialistBodyNotes.
If a change is made on the frmSpecials at present I must manually change the numbers (Column1 SchedheadingNbr) in the tblSpecialistBodyNotes. This goes against the principle of a database having to reenter the same data twice. What I am seeking is some help or direction whether it be through queries, new tables or other means where alterations in the Form can automatically update the data in the Table. Thanks in advance for any advice.
If a change is made on the frmSpecials at present I must manually change the numbers (Column1 SchedheadingNbr) in the tblSpecialistBodyNotes. This goes against the principle of a database having to reenter the same data twice. What I am seeking is some help or direction whether it be through queries, new tables or other means where alterations in the Form can automatically update the data in the Table. Thanks in advance for any advice.
