Referential Integrity

[Desstro]

I have created 4 tables. All Tables have the same primary key. How can I set referential integrity between all of them? I can do it between 2 but not all.



Really what I'm looking to do is once I put the data into the primary key in one table, I want the other three tables to automatically fill in the same data in the related field.

Please help me.

[Datagopherdan]

You would have one primary table and with a unique identifier like an auto-id field. You would then create a relational field in the other tables. Let's say that you are using an auto-id field for your primary key in the main table. You would create a numeric type field in your child fields. You would then set the relationship of your ID field in your main table with the numeric relational field in the child tables. You cannot have values in the relational id fields that are not in the ID field in your main table. That's all you gotta do and then check the referential box.

[Desstro]

Ok....thanks.

Here is a snap shot of what I have. Could you tell me how to do what you previously replied?

[Datagopherdan]

You would set it up exactly as I said. I'm assuming that the "Package Number" in the 3 tables is an auto-id field and that's what you're trying to use as your relationship. You need to remove the primary key from all those tables and change those fields to be numeric types, so you can set the relationships with your main table.

These forums are a great place to get answers but they are more intended to help guide you in development. I would highly-suggest that you take the time to learn relational database basics. Once you have the basic concepts down, which is the foundation then everything else is going to make alot more sense to you and you'll learn alot faster because you'll understand the answers people are giving you and the logic behind them.

Ok....thanks.

Here is a snap shot of what I have. Could you tell me how to do what you previously replied?

[Access_Blaster]

Dan makes some excellent points, if you notice in your three tables you have "Package Number" and in the first table its like this "PackageNumber"

I would use a naming convention on all tables, fields, querys and reports. Also get rid of spaces in your field names, I say this only because it will cause coding problems down the road.