Re: need help creating relation

I could be wrong but I think your problem is the unique index. -- João Cândido de Souza Neto "robert rottermann" escreveu na mensagem news:4dd967a8.5040...@redcor.ch... > Hi there, > > I would like to create a table that optionally links to an other table. > > The field company_id in the fol

need help creating relation

Hi there, I would like to create a table that optionally links to an other table. The field company_id in the following table should be either Null or link to the table tblCompany (`id` ). How do I do that. The way I it now, I can not enter records where the field company_id is null. Thanks