southmoor

Primary and Foreign Key Issues when associated with Value Lists

Discussion created by southmoor on Jul 2, 2012
Latest reply on Jul 28, 2012 by 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!

Outcomes