Table/Query

[JoeyJ]

Hello

I am a first time access user and have a question.

I have two tables.

Table 1 looks like this:

Project Number......................Deliverable
1.........................................apples
1.........................................bananas
2.........................................oranges

The first two column headings of table 2 are the same as table 1. The fields in table 2 are selected via lookup. Once a project number is selected in an entry in table 2, I want to make it so that only deliverables from that specific project are available for selection for the deliverable entry.

For example, is someone selects project number 1 as an entry for table 2, then for that line item, only apples and bananas will be available from the drop down menu for selection of a deliverable.

Can someone tell me how to do this?

 

[ThreeCrow]

Give me some all the field name in Table 2

I'll tell every step needed to get done what you want to do

Or post your data base as attachment.