---
title: Relationships
description: "The plugin supports three types of relationships: - One to many ([read more](/docs/one-to-many-relationships/)) - Many to many ([read more](/docs/many-to-many-relationships/)) - Lookup ([gettings started](/docs/manage-table-options/), [advanced](/docs/advanced-lookups/)) - **Lookup listbox**: adds a listbox containing all lookup values (default) - **Lookup autocomplete**: adds auto-complete…"
url: "https://docs.legacy.wpdataaccess.com/docs/relationships/"
updated: "2025-11-26"
category: Legacy Tools / Templates
---

# Relationships

The plugin supports three types of relationships:

- One to many ([read more](/docs/one-to-many-relationships/))
- Many to many ([read more](/docs/many-to-many-relationships/))
- Lookup ([gettings started](/docs/manage-table-options/), [advanced](/docs/advanced-lookups/))
  - **Lookup listbox**: adds a listbox containing all lookup values (default)
  - **Lookup autocomplete**: adds auto-complete functionality

## TIP

- Use lookup autocomplete for large lookup tables to improve performance
- Use lookup listboxes for small lookup tables to improve the user experience

  [![](https://wpdataaccess.com/wp-content/uploads/2023/11/msedge_n5dTDDoMVS.png)](https://wpdataaccess.com/wp-content/uploads/2023/11/msedge_n5dTDDoMVS.png)