I Need a help!

[Reem]

hi every one
i have continuous forms A & B
form A contain personal information (primary key is MRN)
form b contain Seen Information (primary key is MRN + Date)
information in A&B are in separete Tables and the relationship is one to many
my problem is
passing data between form ( i know it is common thing but because i didn't have any knowlage in Vb
My problem in short story:
when a user enter the information in form A(including MRN) ,he will click a button that goes to form B ,in the form B I want the user to enter only the information that didn't write it in form A ,in other word, i want to see the MRN that the user write in form A is automaticly written in form B
I hope you understand my problem
have anice time!

 

[sam77755]

Reem

I think your problem starts with your design.

table A should have MRN as primary key.
table B should have AutoNumber (or the date if it is only done once) as a primary key then MRN as a foregin key.

For data entry you should create a single form based on a query combining data from both tables at the same time. this will solve it for you.