Default values in WebDB
From: Edward Beemer <ebeemer_at_tas.nl>
Date: Mon, 23 Aug 1999 11:14:22 +0200
Message-ID: <7pr3i2$avv$1_at_zonnetje.nl.uu.net>
[Quoted] Hello guys,
Date: Mon, 23 Aug 1999 11:14:22 +0200
Message-ID: <7pr3i2$avv$1_at_zonnetje.nl.uu.net>
[Quoted] Hello guys,
Consider a table USER_INFO with the fields USERNAME and COMPANY_ID. Consider a table PARTS with the fields COMPANY_ID, PART_NO, DESCRIPTION, where COMPANY_ID + PART_NO form the primary key.
When a user inserts a new PARTS record, I want the COMPANY_ID field to be filled by default with the COMPANY_ID for the user as defined in the USER_INFO table.
How do I get this done?
With kind regards,
Edward Beemer
Received on Mon Aug 23 1999 - 11:14:22 CEST