
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 01, 2020 03:19 PM
I’m trying to make a synced table, but have it synced to another table in the same base. This doesn’t appear to be an option.
The use case is having a single base with a table of Posts (by a user), and also having a table of UserProfiles that display those posts.
Thought the sync was the perfect answer to this, but for some reason it has to reference an external base. My options seem to be duplicating the data manually (edits to posts will be lost) or making a separate base for just the user profiles.
Is there any way to link to a table in the same base?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 01, 2020 03:34 PM
You’re looking for linked records:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 01, 2020 04:18 PM
Welcome to the Airtable community!
It looks like you want a single base with two tables with a many-to-many relationship.
- a table of posts (one row per post)
- a table of users (one row per user)
Depending on your data, you can directly join the two tables with linked records or you might want a junction table.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 10, 2024 01:44 AM
Hi,
Im having the same issue. the link in your post @kuovonne have expired. Is this still the best way to go about solving the problem?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 10, 2024 06:15 PM
