Entering data into to eh tabel the first time

[Lou_Reed]

I am entering test data into my db, just to test it out. I am glad that I did since, I have found several inconsistencies (errors if you will). The first table
let us call it personnel table obviously has a primary key and a many foreign keys that are connected to primary keys in other tables.

Now I am entering some data to show db operation and to see if it works. It has been easy until I get to a foreign key. Then it generates an error that says



You cannot change a record because a related record is required in tables "tblOrg".



Yes, the foreign key is in tblPersonnel and the primary key is in tblOrg.

But you must start entering data somewhere and the tblPersonnel is where I chose to start.

However, if there is a foreign key there and I enter data it generates the above entry. So how do I overcome this.

Must I enter data (actually the same data) into the table with the primary key first? is there another way?

Any help appreciated. Thanks in advance.

Respectfully,


Lou_Reed

[orange]

What makes you think these are errors?

I have found several inconsistencies (errors if you will).

Consider the logic of entering a Child record before entering a Parent record?


You enter data into the independent table before the dependent table.

[Lou_Reed]

It make sense what you say. It is just in most of my tutorials that I have studied this never came up.
It does seem logical to enter data into parent record and then enter data into child record.

As I said it just never came up in the tutorials.

Anyway, thanks for your help.


Respectfully,

Lou_Reed

[Lou_Reed]

In the tblContracts I entered a value 0 for no contracts (the primary key), but it is actually value; it just that says no contacts exist.

That was the parent table - the tblContracts and it only has one entry, which as I said is 0.


Then I went to table personnel and tried to enter for each person in the tblPersonnel. the value 0 (
the foreign key) for contracts.

It said that I cannot add or change a record because a related record is required in tblContracts. But as I said I had already entered the contacts value which I sat at 0.


What is going on? I put the data in the primary key first, then the foreign key.

Any help appreciated. Thanks in advance.

Respectfully,


Lou_Reed

[John_G]

Go to the relationships diagram and check the relationship between tblPersonnel and tblContracts - does it join the two on the correct fields?

[Lou_Reed]

I will check it. I think it does because the line has already been drawn connecting the two. Access 2010 would not have let me draw that line if
the data fields had been different. I will try what you said.

I will get back with the results.


Respectfully,


Lou_Reed

[Lou_Reed]

The foreign key for Contracts is the Number field and the primary key for contracts is Autonumber field.

So yes the fields are the same.

What could be wrong?


Respectfully,

Lou_Reed

[Lou_Reed]

I noticed that I have only a single entry for the primary key, and multiple entries for the foreign key. This as it should be.

It is called a 1 to many relation.

Still the software will not let me input values first for the parent table and second for the child table.

This is confusing.

Respectfully,


Lou_Reed

[John_G]

Is a previous post you stated:

In the tblContracts I entered a value 0 for no contracts (the primary key),

If the PK in that table (tblcontracts) is AutoNumber, you could not have done that, because you cannot enter your own value into an autonumber field.

Can you post of list of your tables and their fields? It would help.

[Lou_Reed]

I think that the attached zip files is shown above. As I said it cannot do tblContracts and tblPersonnel.

Any help on this issue appreciated.


Thanks in advance.

[Lou_Reed]

Looks like you are right. Once, I change my foreign key to reflect the primary (which is never zero), it worked.

Thanks for your help.

Respectfully,


Lou_Reed