data entry forms

[perko]

Hello,

I need to add data using a form.
I need to add experiments that have been performed on existing items, ie yes or no
I have the items in one table and the experiments in the other.
They are joined by the primary key.
When I add the data to a specific item it is changed on the form but it isn't updated in the table when I cross check it.
Default values are set to no for all experiments.
Can anybody please help at all??

Cheers

Perko

 

[directormac]

You said they were joined by the PK, but what type of join is it? It sounds like you're going to want to use a junction table between the two, so that you have maximum flexibility in changing things on either side. Search the forums and Access help for the word junction, you'll probably find what you need.

--Joining Mac