Question Can't auto copy fields from one table to another

[welshdpm]

Hey there

I am new to the world of database writting, I have created a database for my scouts. I have a table 'Scout Interface', which has a field KewstokeID. I have also created a few more tables with the same field in each.

I have created the relationships between each to this field.

The problem I have is that the Value in Scout Interface KewstokeID, does not copy across to the other tables.

Is there a way that I can build and expression or a like that will automatically copy the value from the Scout Interface KewstokeID to the KewstokeID of the remaining tables.

Unfortunately the DB is to big to post (7mb), I can always email the DB if required.

Many regards

 

[April15Hater]

How are you populating the tables?
Are you using bound or unbound forms?

 

[welshdpm]

Sorry for the inexperience, but I am pretty sure that it is a bound form (how would I found out!!)

The main problem I have is when you click on the command button to open up the form in the KewstokeID field all I see is Hashes. When you toggle the filter, after a couple of clicks is will come up with the correct record. But it is not showing the record that has been filtered.

Since my last post I have changed the relationship type so that all records from [scout input:KewstokeID], includes all records to [Table:KewstokeID].

I hope you know what I mean

Managed to get it working now, it was as simple as data entry = No