Nov 4 2008, 06:50 AM
I'm trying to enter data into a query, but I get the error 'you cannot add or change dat because a related record is required in tblChannel'
I'm a bit rusty, any ideas? DB attached
Edited by: PaulBrand on Tue Nov 4 7:30:42 EST 2008.
Nov 4 2008, 01:04 PM
I think your form should be based on tblActivity and then use a combo box in order to populate the channel. Since there is a join between the two tables it is probably preventing the addition of a new activity which resulted in the error.
I think you also have some normalization issues especially with tblCampaign_Event. I see repeating groups (CampaignSupplier, CampaignSupplier2, campaigntype, campaign type2 etc.). Suppliers related to a campaign should be in a separate but related table (1 record per supplier); the same would be true for the types. I see you also have fields marked as total. Storing calculated values is generally not done; you would use queries to get the totals.
Nov 4 2008, 03:25 PM
As jzwp11 has said you need to normalise the DB before proceeding to creating your queries & forms
For information only look at the attached example of how you would create the Form to allow data entry for the process of choosing a Channel & also entering details about an Activity
Hope this helps?
Edited by: mike60smart on Tue Nov 4 15:26:19 EST 2008.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here