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

TIA
Paul

Edited by: PaulBrand on Tue Nov 4 7:30:42 EST 2008.

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.

Hi Paul

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?

Mike

Edited by: mike60smart on Tue Nov 4 15:26:19 EST 2008.