Search results

I'm new to Access and am bumbling my way through creating my first 'proper' DB. (I'm using Access 2007) I'm struggling to fully appreciate how best to structure my DB. If I explain my scenario I’d welcome any comments on how to improve. I’ve simplified the below (mainly by removing the fields...

Apologies. I'm using Access 2007. So the validation would need to be on the form, rather than in the table? I'm pretty new to Access so was planning to get the db structure up and running before I started on designing forms/switchboards etc. Is that a logical way to work?

I'm wanting Field2 (number) to be required only if Field1 (Yes/No) is set to Yes. Is there a simple way to do this? I went down the road of using an IIF function in the validation rule of Field2, but this didn't seem to work. TIA