Event proceedure for text box

[Alum]

I have a series of 5 forms. Each is connected to the other by a primary
key/foreign key. On a couple of the forms, I want to view this same key on
both forms. However, the tables cannot have referential integrity because
they are all one-zero to many-zero relationships. We may enter information
in one form and not need/have any of the other information. Therefore, some
primary/foreign key relationships may or may not exist. How can I create an
event that with the click of a command button relates the identified primary
key in one form to the same foreign key so it will display the same
information taken from the same field in an underlying table.

I was thinking maybe I could use an On Lost Focus event. But, since the
relationships may or may not exist this may not work every time.

For instance, I need to view an RMA # in the RMA form, and after it is
inserted into the RMA form it would be helpful to also view it in our Phone
Log form. Primary key RMA # in the RMA table, and foreign key RMA in the
phone log table need to have the same referenced cell in the table.

I know this in convoluted, but any clues as to how I would use Access VBA
for this would be appreciated.

Let me know what information I'm missing.

 

[shafik]

I have a series of 5 forms. Each is connected to the other by a primary
key/foreign key. On a couple of the forms, I want to view this same key
on
both forms. However, the tables cannot have referential integrity because
they are all one-zero to many-zero relationships. We may enter
information
in one form and not need/have any of the other information. Therefore,
some
primary/foreign key relationships may or may not exist. How can I create
an
event that with the click of a command button relates the identified
primary
key in one form to the same foreign key so it will display the same
information taken from the same field in an underlying table.

I was thinking maybe I could use an On Lost Focus event. But, since the
relationships may or may not exist this may not work every time.

For instance, I need to view an RMA # in the RMA form, and after it is
inserted into the RMA form it would be helpful to also view it in our
Phone
Log form. Primary key RMA # in the RMA table, and foreign key RMA in the
phone log table need to have the same referenced cell in the table.

I know this in convoluted, but any clues as to how I would use Access VBA
for this would be appreciated.

Let me know what information I'm missing.