Question look up from multiple tables

[spooky30]

i am new to access and trying to make a hospital data base.

1. I am making a banking transaction table
2 There is a field in banking transaction where i have to input name of the
party
3. this party can be doctors/suppliers/or staff each having seperate tables


I want to produce drop down list in bnk_tr table which can show a selection list of name field from all three tables,name field is common to all three dr/supp/staff tables

pls help

 

[pbaldy]

SELECT NameField
FROM FirstTable
UNION ALL
SELECT NameField
FROM SecondTable
UNION ALL
...

You might want to add a field to designate which table they come from.

 

[spooky30]

Thanks for the quick replay