Here are the details to two versions of Product Tables, one for Access 2000/97 and one for SQL Server 7. Not all of these fields are necessary in one database. For example ... have a SupplierAvailable ...

It is important to take time to design any queries that may need to be implemented later. Query design does not need to include specific SQL (Structured Query Language) commands. SQL will only be ...