Hi all, this is my first Database Development for a friend who has just started his own business.
He inspects pieces of Plant / Machinery / Equipment and issues certificates following their inspection.
The database is relatively simple co-ordinating, Clients (Accounts), Contacts, Pieces of equipment and their addresses / locations.
As you can imagine, there are alot of relationships between all the above and their many addresses.
I have managed to complete this in principle, however, during browser mode, the Layout has to have the "Primary Key / Serial Number" displayed within a field, otherwise all the related fields dont auto populate.
This is fine, but looks "messy"
I am finding it hard to explain and have therefore uploaded a video on YouTube:
Please, please watch and advise.
Thanks in advance!