RelationShip between Tables

[joe357]

Everyone,

I am having trouble with relationships between two tables. example I am trying to have information from one table populate in another as a new record.

What am i doing incorrectly? I have 4 fields in the original table that need to cascade to the original. The first table is for keeping the data and the second table it to calculate the yearly maintenance.

When I try to create the relationship i get the error below.

Data in the Table "Trip Cost Calculator" violates referential integrity rules.

I am new to programming and books work well but they do not cover the exceptions.

Thank you,

[orange]

Research NORMALIZATION.

Show us your table designs.

[joe357]

What part of the design the Data Model or the actual design mode to determine if i have things defined correctly

[Missinglinq]

...I am trying to have information from one table populate in another as a new record.

...I have 4 fields in the original table that need to cascade to the original.

...The first table is for keeping the data and the second table it to calculate the yearly maintenance.

I have to tell you that the wording here is more than a little curious!

1. With the exception of a Primary Key, i.e. a Field that uniquely identifies a Record, you do not store Fields in multiple Tables.
2. I cannot even guess what "I have 4 fields in the original table that need to cascade to the original" means.
3. Tables are never used to Calculate anything! Queries are the usual Objects intended for data manipulation, including Calculations, although manipulation can also be done in the Module of a Form.

I think you need to provide us with an explanation of what you're trying to do, from a practical standpoint, in order for us to help you.

Linq ;0)>