Update the properties of a multivalued field For more information, see Create or delete a lookup field and Create or delete a values list field. Note Access has other types of list fields: a lookup field that looks up matching data in a table (such as an ID field that looks up a Full Name) and a values list field that stores only one value with valid values defined in a property. For a database example that uses multivalued fields, see the Issue Tracking template. ![]() An Access multivalued field is also useful when you work with a SharePoint list that uses a Choice column. This kind of data structure is called a many-to-many relationship. One employee can own several issues, and each issue can have several employee working on it. For example, you want to track employees working on issues. ![]() But in Access, you can also create a field that holds multiple values (up to 100). In most database systems you can store only a single value in a field. ![]() Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |