Acc2000: Choose form field & display results in another
Posted: Fri Jan 24, 2003 2:37 am
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
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