Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Anyway to have related table fk not required field?

Quote Reply
Anyway to have related table fk not required field?
I know foreign keys, by their very nature, are supposed to be NOT NULL. However, I'm wondering if there's anyway to work around that with related tables in DBMan SQL. I would like the ability to create a relationship and create a select menu on the related table based on the primary table, but have it be an optional field. Is this possible? Many thanks for any assistance.

Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund
Subject Author Views Date
Thread Anyway to have related table fk not required field? hennagaijin 3623 Dec 21, 2002, 5:25 AM
Thread Re: [hennagaijin] Anyway to have related table fk not required field?
jaspercram 3493 Dec 24, 2002, 1:26 AM
Thread Re: [jaspercram] Anyway to have related table fk not required field?
hennagaijin 3509 Dec 24, 2002, 4:17 AM
Thread Re: [hennagaijin] Anyway to have related table fk not required field?
hennagaijin 3469 Dec 30, 2002, 2:14 PM
Post Re: [hennagaijin] Anyway to have related table fk not required field?
604 3460 Dec 31, 2002, 11:33 AM