First name surname table to table

[brianstockwell]

Hello - new user here. I need help in setting up my database to be used in a non profit sports club.

I have one table containing FirstName and LastName (this will build into my membership information file with lots more detail eventually) and another table which is to be used as a class register.

I want to extract information from the Membership table and use it to produce Class Register table.

I wish to do this by entering a first name or first letter of a name and have all the available portential matching records come up in a drop down box to be selected from.

I have tried every way I can using relationships, codes etc and cannot make this work. I cannot move forward to build the database until this is solved.

Can you help??

Many thanks

Brian

 

[EdFred]

Sounds like you need a combo box and a query with an SQL statement for the Row Source for that combo box that should look something like this:

SELECT [Table1].[LastName] FROM [Table1] ORDER BY [LastName];

The control source for this combo box would be the table that you are writing the information to.

 

[neileg]

Bit more to it, EdFred.

Search for 'cascading combo' in these forums to see how this works.

 

[EdFred]

Maybe I'm reading the question wrong, but I've been doing it (or at least what I think he's talking about) that way for 10 years. Maybe I just haven't evolved enough.

Yeah, I use afterupdate on the first combo box and in the second one limit by the value in the first one. I'm a dino.

 

[neileg]

No, EdFred, I didn't mean you were wrong, I just meant it needed more explanation. Cascading combos is simply the term used to describe exactly what you have been doing for the last ten years!