Skip to main content
Solved

1 Base or 3 bases for restaurant

  • August 16, 2022
  • 2 replies
  • 23 views

Hello

Can someone give me an advice?
Sorry, but my english is not great to explain everything as I want.

For a restaurant, I have recipes, with ingredients, and they came for vendors.

What is best? 3 bases linked, or just 1 base with everyting?

The 3 bases, that look logical to me, are: recipes, inventory, and vendors.

  • recipes, with photo and calcs to estimate costs
  • inventory, to track ingredients costs from different vendors, quantities in stock, and reorders
  • vendors, where I can see their ingredients, with their contacts, and track the payments

Ingredients is the only thing that must equal in all the 3 bases.

But I never did any base, so maybe I’m thinking wrong.

Thanks in advance

Best answer by Mohamed_Swella1

Hi @frank_laureano ,

Welcome to Airtable Community !

You’re English is good enough no worries :slightly_smiling_face:

The idea of 1 base or 3 bases all depends on the amount of data you have. I always recommend 1 base for everything. But if you think you will have more than 50K records (assuming you are on the Pro plan) then I would recommend 2 bases (not 3). One for recipes and inventory, one for Vendors (that you will sync to the other base)

2 replies

Mohamed_Swella1
Forum|alt.badge.img+17
  • Inspiring
  • 1030 replies
  • Answer
  • August 16, 2022

Hi @frank_laureano ,

Welcome to Airtable Community !

You’re English is good enough no worries :slightly_smiling_face:

The idea of 1 base or 3 bases all depends on the amount of data you have. I always recommend 1 base for everything. But if you think you will have more than 50K records (assuming you are on the Pro plan) then I would recommend 2 bases (not 3). One for recipes and inventory, one for Vendors (that you will sync to the other base)


  • Author
  • New Participant
  • 1 reply
  • August 16, 2022

Thanks

So I will try 1 base.
Time to study how to do that!