Alterations & additions / updates required to ERM drawing:
Add Visual Numbers table
New visual accession number field added to Visual Collections table. PHO number can be deleted now? PHO without prefix to stay temporarily for import purposes.
Relationship now uses visual accession number field instead of PHO number
Customisation changes to Visual Collections table (e.g. URL button links, name changes)
Relationship is now working
for PHO numbers but URL and visual collections form needs styling.PR, PD, PD year, CC, P, P year visual accession series, using the same intermediary table.PHO, PR, PD, PD year, CC, P, P year series data into Visual Collections table10