I have created a salesbook application for our company and i've been asked to do an update to include some more features that they want.
With the salesbook i have roughly 20+ tables linking to one table.
The tables include information like, model prices, freight, warranty, customer information, salesmen information, discount structures. brand information, additional options for the equipment and so on. Which all these tables feed the main form table to create your quote.
With that said, my question is there a limit on how many tables you should or shouldn't link to one table?
Is there a best practice for how much is too much? Should i be splitting some tables away from the main form?
What do you guys think?