Part A – build one or more base(s) of 3rd party architectural product information (lighting and electrical equipment for commercial architectural projects) that we specify on a regular basis. This may have 10 to 20 data points for each entry.
Part B – Create a template that allows my team to create a unique schedule for an individual project that will draw information from that master base. When we need to add something new, I want to add it into the project, but have that information propagate back into the master database also.
we will have PDF files associated with each entry, but any PDF may be usable across several base data fields. ie product A has a PDF data sheet, and we carry 10 versions of that product in the master base, each entry needs to have that PDF tied to it.
Initially, we should sync up on a zoom call for 15-20 minutes, I can demonstrate how we do this with Google Docs (and why it has serious faults).
thanks
Mark