Hello. I’m a complete newbie to creating databases and I’m trying to create one in Base to help keep track of material for my landscape installation business. I’m looking for basic advice on setting up my database. I’m hoping to input plant material needed for each upcoming project and then be able to print out lists of plant material needed for various combinations of projects. My question is, do I create a different table for each client, or make client a field in the database? Any help on the structure of this simple database would be greatly appreciated.
Thank you.