DB for Fisherman.. requesting help

I have a fishing vessel with a different crew of three people when they go
out for a fishing trip. I have started building a database to try to capture
what has been caught during each day of the trip by each fisherman and I am
having a dillemma with one of the forms. Here is the data example:

Trip 1 lasted 3 days, Jan 1-3 with Joe, Jack and John.
Trip 2 lasted 3 days, Jan 6-8 with Adam, Eve and Bert.
Trip 3 lasted 3 days, Jan 9-12 with Jack, Bert and Les.

I have designed the tables as logical as I could, yet I run into the problem
at the catchlog entry form, where I wanted a dropdown list of the fisherman
names, which points to the fisherman table. However I would like the
dropdown table showing only the names that are currently on that trip only,
otherwhise the list will be miles long by end of the year.. What am I do? It
feels I missed some logic...

Your help is appreciated,
Robert

suggest you post your tables structure, indicating primary and foreign keys
and what relationships you've established between them. an
easy-to-understand structure for posting is

TableName
FieldName (primary key)
FieldName
FieldName
FieldName (foreign key from tblName)

once we understand your tables/relationships setup, it will be easier to try
to solve your data entry issue.


"Robert C." wrote in message
...
I have a fishing vessel with a different crew of three people when they go
out for a fishing trip. I have started building a database to try to
capture
what has been caught during each day of the trip by each fisherman and I
am
having a dillemma with one of the forms. Here is the data example:

Trip 1 lasted 3 days, Jan 1-3 with Joe, Jack and John.
Trip 2 lasted 3 days, Jan 6-8 with Adam, Eve and Bert.
Trip 3 lasted 3 days, Jan 9-12 with Jack, Bert and Les.

I have designed the tables as logical as I could, yet I run into the
problem
at the catchlog entry form, where I wanted a dropdown list of the
fisherman
names, which points to the fisherman table. However I would like the
dropdown table showing only the names that are currently on that trip
only,
otherwhise the list will be miles long by end of the year.. What am I do?
It
feels I missed some logic...

Your help is appreciated,
Robert