ربط الاستعلامات

السلام عليكم

عندي مشكلة في برنامج اكسس :blink: وهي

كيفية ارسال بيانات ادخلت بواسطة المستخدم في الاستعلام الاول اريد ها ان تظهر في حقول معينه في الاستعلام الثاني

ولان الاكسس اللي عندي نسخه انجليزيه فسأوضح مشكلتي بالانجليزي

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!

(h)