In an attempt to arrive at 2NF or 3NF, I have created several tables from a single table to avoid what would become redundant data: city table w/zip code, state table, type of work table etc. Of these, there are several one to many relationships and one, many to many relationship. Problem I'm experiencing, the city and state tables contain the primary key as there should only be one of these while the customer and job tables contain the foreign key. In a customer record entry form for instance, to record a new customer, what is the recommended method for adding the new customer as well as being able to select the city and state? beings how the primary key is in the city and state table, the error I get tells me the parent record must exist first before the child record. I realize this but am at a quandry at how to get it to work properly.