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

    Primary and Foreign Key Issues when associated with Value Lists

    southmoor

      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:

       

      http://youtu.be/31O3Hk0gzoY

       

      Please, please watch and advise.

       

      Thanks in advance!