Re: Combination of fields must be unique

Jeff, I hope this explains it better:

I am developing a database to keep track of test reports.

All test reports are available as a hard copy.
Some of these test reports are available as PDF.
If a report is available as a PDF there could be two files Report and Photo
attachment.

I can’t set the fields as required, as there is not always a PDF report. And
if there is a PDF report there is not always a photo attachment.

In my table I have two fields PdfReport and PdfPhotos.
The user enters the path and file name using an open file dialogue box.

I want to ensure that any file is only entered into the database only once,
wether it is into PdfReport or PdfPhotos.

Thanks for your help,
Seth


"Jeff Boyce" wrote:

> Seth
>
> I'm not clear on your requirements...
>
> You want Field1 to be "unique", but no value must be entered. So, if in a
> couple rows you had no value entered in Field1, you'd have two rows with
> Nulls in Field1 -- I don't believe these are unique.
>
> Ditto for Field2.
>
> And your comment:
>
> > But I am still able to enter the same value in both Field1 and Field2
>
> seems to imply that you also want to ensure that whatever is entered in
> Field1 is never entered in Field2 for the same record.
>
> Perhaps if you explained a bit more about what you hope to accomplish with
> this arrangement, rather than how you are trying to do (something
> undefined)...?
>
> Good luck
>
> Jeff Boyce
> <Access MVP>
>
>
.

Relevant Pages

  • Re: Safespeeds fake coppers.
    ... You really haven't got the hang of this quoting thing have you? ... in order to prove with peer-reviewed data that speed cameras save ... So far Jeff you've screamed "HYPOCRITE" at me because you hadn't read ... "Appendix H" of the 4th year report? ...
    (uk.rec.cycling)
  • Re: Access query performance
    ... Thanks for the advice, subreports did the trick. ... troubleshooting advice on whether these types of problems are query or report ... "Jeff Boyce" wrote: ... > The first thing to check on slow queries is that fields used for selection ...
    (microsoft.public.access.queries)
  • RE: Help needed in sending email from Access.
    ... progressed to 'Dim Report As MailItem' and stopped again. ... "Jeff C" wrote: ... reference libraries to make sure that you have Microsoft Word 11.0 Object ... It stops on 'Dim wdApp As Word.Application' with Compile ...
    (microsoft.public.access.reports)
  • Re: Report Help Needed
    ... Jeff - Presentation is key. ... a report would be much better. ... 88-option Option Group could you not just present the name of the ... where each county has an ID number. ...
    (comp.databases.ms-access)
  • Re: Printing a BMP bitmap
    ... Jeff, I've done this before, and the trick I found was to simply rename the ... BMP each time you print. ... The report "seems" to remember the first picture that it is ... >>> How do you print a bitmap where the bitmap that you will be printing is ...
    (microsoft.public.fox.programmer.exchange)