1 Base or 3 bases for restaurant

[frank_laureano]

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

[Mohamed_Swella1 · Accepted solution]

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)

[frank_laureano]

Thanks

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