Page 1 of 1

Acc2000: Choose form field & display results in another

Posted: Fri Jan 24, 2003 2:37 am
by Love_Daddy
Hi guys,

How do I pass one form field to do a search/query in another table and display that field. (Data Duplication)

Scenario:

table1 fields:

ID = 1 (P.K)
Name: Romeo
Surname:Surname

Table2 fields:

ID = 1 (ref key)
salary = 1000
Dept = IT

And you have a form that displays name and surname and there's one button that when clicked displays the salary and department in another form for romeo mabasa.

Hope this makes sense...

Please help