I have this error that has started
Column 'Money to / From…?' in Table 'ADF2' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
From this data, I am pretty sure it is in relation to rows 8 & 9 but this data is unique.
FE | Matter No | Clients Name | Money to / From…? | Description of Monies Received | Expected In £ | To Send Out £ | Date Expected |
| | MAJ004-0001 | Maj | Santander | advance | £73,415.00 | | 23-Feb-17 |
| | MAJ 004 0001 | MAJ | Direction Law | purchase | | £91,500.00 | 24-Feb-17 |
| | MEE015-0003 | Meek | MR& MRS MEEK | CGT a/c payment | | £127,552.60 | 20-Feb-17 |
| | CRA112-0001 | Craig | client | bal due | £379,234.80 | | |
| | CRA112-0001 | Craig | Thackray Williams | purchase | | £369,139.80 | 24-Feb-17 |
| | WAK016-0001 | Wakeford & Waghorn | client | bal due | £73.15 | | |
| | WAK016-0001 | Wakeford & Waghorn | Santander | advance | £108,765.00 | | 22-Feb-17 |
| | WAK016-0001 | Wakeford & Waghorn | Help to buy ISA | HTB Isa | £900.31 | | |
| | WAK016-0001 | Wakeford & Waghorn | Help to buy ISA | HTB Isa | £925.10 | | |
| | WAK016-0001 | Wakeford & Waghorn | Sharratts | staircasing and apportionments | | £37,278.56 | 23-Feb-17 |
| | WAK016-0001 | Wakeford & Waghorn | Anthony Stockton | purchase | | £91,250.00 | 23-Feb-17 |
| | COO205-0002 | Cooley | O'Neill patient | sale | £229,500.00 | | 23-Feb-17 |
| | COO205-0001 | Cooley | Nationwide | advance | £125,000.00 | | 22-Feb-17 |
| | COO205-0001 | Cooley | Keystone Law | purchase | | £378,000.00 | 23-Feb-17 |
| | COO205-0001 | Cooley | client | bal due | £14,541.00 | | |
Is there any way to stop this error?
