relationships causing locked cells

[andyswinburne]

Hi,

I have a table [Bowler Details] and an attached form and also a table [Bowler Scoresheet]. The attached form for the bowler scoresheet takes all the [Bowler Scoresheet] fields and then a couple of the [Bowler Details] fields.

It displays the details fine, but it doesn't let me input data into the [Bowler Scoresheet] fields. The relationship between the tables is that all the [Bowler Details] have all the [Bowler Scoresheet] fields.

So if you open the [Bowler Details] tabel then there is a + box which opens a [Bowler Scoresheet] record for each of the records. It lets me input the scores fine into the table but when i try and use the form with the correct contol source it is just as if the field is locked and no data can be entered.

I think that it must be something to do withg the relationship but cannot think what.

cheers

Andy

 

[dan-cat]

If you post your db - I'll take a quick look for you

 

[andyswinburne]

Hi,

I cant post my db as it is too big. Could i email it to you directly? If you mail me with your address then i can send it to you normally without the size restriction. Sorry for the inconvience.

cheers

Andy

 

[dan-cat]

ok have just emailed you