Child and Master links

[harrop11]

Hello,
To say the least i am very much a beginner to access and while creating a database for a college assignment i've come accross a small problem which i cannot for the life of me find a solution.

Here it goes:
the database consists of 3 tables which are joined by the central table which has foreign keys for both of the other tables. I have created a form which consists of all data.
When i try to input a new record via a foreign key i'm told that the record does not exist although the form works fine if the record does exist in the mater side. Is there any way to allow this and yes, enforce referential integrity is unchecked.

If there is not such a simple answer to this i've thought there may be ways around this like an event on update of the foreign key to create a new record containing the data in that field.

I would very much appreciate any help anyone may be able to offer.

Thanks

 

[SOS]

Hi there!

Can you post your database (what you currently have)?

See here for directions on how to upload

 

[harrop11]

Here you go.

While your in there i need some way of a query diplaying if the registration has been logged under an incident in the past 24 hours but thats just for browny points.

Thanks

 

[SOS]

I'll have to look when I get home. I don't have 2007 here.

 

[harrop11]

Hi,
I'm guessing this one isn't as easy as i thought (hoping) it might be. Well thanks anyway, i'm guessing i'll have to take a different approach.

 

[Rabbie]

As I don't have A2007 here I am not exactly sure what you have but in principal the The child records should have the PK of the parent record stored as a FK.

You should be able to add new records to the child record by using a Form/Subform setup based on a query linking the two tables. By selecting/creating the correct Parent record before you add the Child record you should avoid any problems

 

[harrop11]

Thanks for responding Rabbie.
I thought this would be the case but upon trying to do this i found a different issue,
http://www.access-programmers.co.uk/forums/showthread.php?t=173510