6 Replies Latest reply on Jul 28, 2012 12:44 AM by southmoor

    Primary and Foreign Key Issues when associated with Value Lists


      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!