Lookup query

[buchasia]

I have Database having name of 10 company (CO Table) and each company there is 3 director (Dirctor Table) also so there is 30 Data raw in simple query

Now i am crating a Meeting Table for Each Co in which only that director will hold meeting who is associated with his company But while Creating Meeting table i want to filter the name of Director to 3 only so it will show me only 3 director name only not the 30 data so only show that director name as the first filed is company name and second filed is Director Present , Which Query or Function is help full to me plz guide thanks

[CJ_London]

sounds like your query needs to use TOP and ORDER BY

SELECT TOP 3 Names FROM myTable ORDER BY Seniority

[buchasia]

I need While Updating Meeting table when i update Meeting Data of in director Filed (Lookup ) it show me only name of that director only whose co Name is Data is entering so it show me lesser name of director name which is relevent not show unnecessary name of all the director or other company.

Thanks

[CJ_London]

I don't understand the question, please provide an example

[buchasia]

I don't understand the question, please provide an example

givemeyourcontactnoplz

[buchasia]

i have attach the example data base also in my prevsious reply give me your contact no if possible or sky pe so i can contact to you thanks

[CJ_London]

sorry, cannot provide my contact details, please use this thread for communications.

Your attachment has three tables, nothing else. using the data in the tables, provide an example of that you want to achieve - either typed out in the post or attach a spreadsheet to demonstrate