Changing data on both sides of a field in a many to many relations

S

SharonInGa

If Me.IO_BOL > 1 Then
Me.IO_PrimaryKey = Me.IO_BOL
Else

Me.IO_PrimaryKey = Me.IO_PO
End If

the IO_PrimaryKey is populated based on whether the BOL or PO fields are
completed. The IO_Primary key has a relationship with the many to many
table, therefore the Primary key in the many to many table is also populated.

I get an error if I have to change the data in the BOL or PO fields. How
do I change the data in the Primary field name in the many-to-many table as
well if I have to change the original BOL or PO fields?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Creating a Search using a combo box and then creating a report. 4
Append Crosstab Query to Existing Table 0
How to have two tables on same line? 1
Format change in merge data - Bold formatting after a comma 0
Creating a key on the input form 1
sqlite-odbc write conflict 2
Many to Many join in a database 0

Top