Adding new data to existing Table

[Dragonrider]

Please bear with me, first post, trying to get to grips with Access for work!

We (a primary school) had a "bespoke" database set up using MS Access by someone who has long left the area and now we need to make changes and I, as the most computer literate person on site, have been volunteered to make these changes.

My level is beginner (for now) and my first job is to add some new options to a "Titles" table, four columns, six records. Column1 = ID#, Column2 = Male Titles, Column3 = Female Titles, whilst Column4 seems to hold items from Columns 2 & 3.

If I add a futher option, I get the error "Can't perform cascading operation: Entry must be one of the Titles as featured in the drop-down box or in the Titles table.

Now, as far as I can tell, I HAVE added the new option to the Titles table, and they DO show in the drop down box in the main spreadsheet display, BUT the error comes back as soon as I try to confirm the new title.

Any ideas please?

 

[w1dge]

Please bear with me, first post, trying to get to grips with Access for work!

We (a primary school) had a "bespoke" database set up using MS Access by someone who has long left the area and now we need to make changes and I, as the most computer literate person on site, have been volunteered to make these changes.

My level is beginner (for now) and my first job is to add some new options to a "Titles" table, four columns, six records. Column1 = ID#, Column2 = Male Titles, Column3 = Female Titles, whilst Column4 seems to hold items from Columns 2 & 3.

If I add a futher option, I get the error "Can't perform cascading operation: Entry must be one of the Titles as featured in the drop-down box or in the Titles table.

Now, as far as I can tell, I HAVE added the new option to the Titles table, and they DO show in the drop down box in the main spreadsheet display, BUT the error comes back as soon as I try to confirm the new title.

Any ideas please?

Its difficult to say exactly why this is the case. Is your Titles table related to any other tables who's primary keys do not allow the selection of the additions you have put in place? This could explain the Cascade error you mention

Can you check the relationships between your tables and report back?

You could also have constraints put on the data that is allowable in the fields you are trying to update. Simply adding extra data to your drop down would not update the constraints, and when you try to select a value that is not allowed, you get the error.

Sorry if this is a bit vague, but theres not much to go on from your description I'm afraid

 

[Dragonrider]

Its difficult to say exactly why this is the case. Is your Titles table related to any other tables who's primary keys do not allow the selection of the additions you have put in place? This could explain the Cascade error you mention

Can you check the relationships between your tables and report back?

You could also have constraints put on the data that is allowable in the fields you are trying to update. Simply adding extra data to your drop down would not update the constraints, and when you try to select a value that is not allowed, you get the error.

Sorry if this is a bit vague, but theres not much to go on from your description I'm afraid

Thanks for getting back to me so quickly, appreciated!

Okay, I said I was a beginner, so how do I check any relationship between tables please?

I did find at one point a place to set the allowed values for the form, but have currently lost that!

Oh dear, I thought I'd actually done quite well in describing what I was trying to do.

 

[Wiz47]

Thanks for getting back to me so quickly, appreciated!

Okay, I said I was a beginner, so how do I check any relationship between tables please?

I did find at one point a place to set the allowed values for the form, but have currently lost that!

Oh dear, I thought I'd actually done quite well in describing what I was trying to do.

Sometimes (when the issue is complex) it's easier to upload an example of the database. Even with the best descriptions of an issue, there can be certain elements that are missing, making it nearly impossible to diagnose the problem without having "hands on" so to speak. With the database at hand, many here can go directly to an area where they think there might be a problem and check that first. Without the database to work with, it can quickly become a game of 20 questions.

 

[Dragonrider]

Sometimes (when the issue is complex) it's easier to upload an example of the database. Even with the best descriptions of an issue, there can be certain elements that are missing, making it nearly impossible to diagnose the problem without having "hands on" so to speak.

Thanks, I'll have to discuss this, but I fear I know the answer to this already. Not possible, as it contains a lot of highly confidential info so there is very little likelihood that this could be uploaded anywhere.

I guess I'll just have to keep plodding away then, at least until the powers that be decide to pay someone to look at it!

 

[Wiz47]

Thanks, I'll have to discuss this, but I fear I know the answer to this already. Not possible, as it contains a lot of highly confidential info so there is very little likelihood that this could be uploaded anywhere.

I guess I'll just have to keep plodding away then, at least until the powers that be decide to pay someone to look at it!

What you can do is make a "stripped down" version that doesn't contain any personal data. Just enter some fake data (enough for it to work) and then the group here can have a look at it.

 

[neileg]

Open your database, go into Tools/Relationships and do a screen print. Post it here and we may be able to progress this. Mind you, this will only help if the designer has used the relationships window in the first place!

 

[Dragonrider]

Open your database, go into Tools/Relationships and do a screen print. Post it here and we may be able to progress this. Mind you, this will only help if the designer has used the relationships window in the first place!

Apologies for delay, have tried to get permission to do as Wiz47 suggested, no joy at present, but here is relationship dump as neileg asked.

 

[neileg]

Yuk! The design is very un-normalised. I hope this wasn't set up by someone who got paid for it!

However, since the Titles table is only a lookup, I can't see this being a serious issue. You need to add your new titles to the Titles table itself, not to [Child Data]. However, I think you've already done that. So without the db to look at, I can't help.

 

[Dragonrider]

Again, sorry for delay, had great problems emptying the darn thing! Every time I tried, the program crashed!

Think I've done it though. The database files are at http://wharfedalefestival.co.uk/wharfe/downloads/MSADS.zip and I'll add the username and pw (not mine I assure you).