General Table and Key Setup Help Requested

[aml5171]

I have not created a database from the ground up in a few years but am familiar with using access and the general methods. What I am trying to create is a database with data on a number of "Owner/Clients", all the "Vessels" each client owns, the "Vessel" details such as type of vessel, price etc., and then a final table on the "Policy Details" for each individual vessel. I have a good idea of the 4 tables I definitely (Owner Table, Policy Table, Product Table, and Vessel Table) but I am not sure what I need to set as primary, and foreign keys to keep all the data properly linked. The end result I am looking for is a main database table where we can type in for example a specific Vessel Name, or Owner Name and it would display all of the vessels owned by that owner and than all the corresponding information for each vessel. I have attached an excel sheet that displays a diagram of what I would like to build and an ideal end result. Any advice on how to set up these tables and or keys would be greatly appreciated as I feel I can build the database once I know what direction to start in with the tables. Thank you all in advance for taking the time to read this and for any help you can provide.

 

[Guus2005]

Browsing text is a way to quickly find the keywords of what the text is about. Due to the lack of newlines the reader must read the complete line to understand what it is what you are writing. See it as a newspaper. It has columns of 30 letters each. So perhaps you have an easy question, which can be answered by anyone, but s difficult to get to the end of your text. just as it is in my answer. So please use the enter key, punctuations and question marks to emphasize to part where the question should be. HTH