rexkwilliams

Gentlemen, Thank you for your replies. I will first try the foreign keys because if I cram all of the other fields into one table - well, I will have a hundred or so fields. I will let y'all know how it works out. Thank you.

I am sorry for having to ask, but I did try to help myself first, but I am not sure I really know what to terms to use to search. Background: I have a DB that I am developing that tracks requirements for individuals. Each individual is assigned a auto serial key in a parent table. Each individual has satisfy many training requirements and has to file personnel information; there are many training and personnel categories. Each major category has an individual table and an auto serial key assigned to it and I think I have them attached to the primary key in the parent table. So the individuals table is the parent and the remaining tables are the children. The Issue: When I create a new record in the individuals table I cannot get another table (StripMap) to create a new record and display a google map of the individuals residential address. The StripMap table has an auto serial key and a container field. Inside the container field I have setup the google map which is pulling the address information from another table that contains personnel information. I can't figure it out, maybe I am going about it the wrong way. Thank you for your assistance.