Acc2000: Choose form field & display results in another

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Love_Daddy
Forum Commoner
Posts: 61
Joined: Wed Jul 10, 2002 6:55 am
Location: South Africa
Contact:

Acc2000: Choose form field & display results in another

Post 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
Post Reply