Help with Forms please

[chrisguk]

Hi there,

After various suggestions I have followed lots of tutorials on how to make databases and making relationships between them.

So now I have 2 tables called the following and there fields are underneath the table names:

tblsites
siteid (number, Primary key)
add1 (text)
add2 (text)
add3 (text)
pcode (text)
tel (text)

tbllog
logid (autonumber, primary key)
siteid (number)
query (memo)
date (date/time)

I have a one to many with referential integrity checked in the relationships window.

Ok my difficulty is I create 2 forms based on the tables above. tblsites is the primary table. The forms are called:

f_sites
f_log

I open f_sites, in which I have created a button to open f_log. I used the wizard to create the button and selected show specific records.

When the f_log form opens I want the field "siteid" to populate automatically with the sideid from f_sites. This is not happening.

What am I doing wrong?

I have search the internet but struggle to find the answer. I really hope someone will help me with this problem.

Thanks in advance

 

[Adam Caramon]

What am I doing wrong?

If I'm understanding you correctly, I think you're thinking referential integrity does something that it really doesn't.

Essentially, Access does not know what number to automatically put into tbllog's siteid.

If you want to upload a copy of your database (version 2007 or earlier), it might be easier to figure out a solution to your problem.