I've been put on the job to do a database for a condominium and its inhabitants in order for them to be easily found as it's all about the central heating unit: it's not so much difficult as some of the things I got asked to do I can't seem to actually do them in Base. For starters:
- 1. It was asked of me to create a field that has the YES/NO boolean value (the field being "Can be Contacted Via E-Mail", y/n value) that, if it's a YES, needs to ask me the e-mail field to be filled out. He then wants it repeated for the dilation of the complete payment sum in the nominal Customer's table (the field being "Paid in Installments", y/n value), so if it's YES I need the table to ask me to fill in the individual installment sum and the final amount that needs to be paid, if it's a NO then the value of the "Nominal Installment" can be null).
2. It was asked of me to have a Fiscal Code field (my primary key for the Customer's list) with two of these fields as well:
a YES/NO field for the VAT Number if it's a company (the field is "Company?" and the field is YES/NO - if YES, I need it to require the VAT field to be correctly filled out, if NO it's good even if the value is null).