Join Gini von Courter for an in-depth discussion in this video Deleting relationships and tables, part of Creating Access Web Apps in SharePoint 2013.
- I'm back in our Issues web app,…and I want to remove a table.…As you may recall, I don't have a need…for a Customers table in my Issues app…because I'll only have internal people reporting.…So I wanna remove that table.…You might be tempted just to go here…and choose Delete.…I'm gonna do that, although it's not going to let us.…It's going to provide us with some helpful information.…If I delete this table, it says,…"You won't be able to undo this. Are you sure?"…Notice that the default is Cancel,…because it really will be gone.…
There isn't an Undo for this.…I'm gonna click Delete, and it says,…"Whoa, whoa, whoa! You can't do that."…The reason is that there are relationships…in the database.…The Customers table is used…as a look up table in the Issues table,…and it says I need to remove the field Customer…from the table Issues.…The reason I suggest that you go ahead…and try to delete is,…if there is more than one,…you'll actually get the information that you need to know…where you need to be able to go and remove fields.…
- Creating a new app
- Building tables from different sources
- Creating relationships between tables
- Working with views
- Using macros for automation
- Saving your app in an app package
Skill Level Intermediate
Q: The "Using the If macro action" movie seems to end in the middle of troubleshooting. What am I missing?
Q: This course was updated on 08/25/2017. What changed?
A: New videos were added that cover changes for Access Web Apps and migrating Access Web App data to SharePoint Online.