Search results

My combo box displays LastName | FirstName | ClientID (invisible). The result populates the rest of the form with the client information. When I select "Smith | xxxxx| it always populates with the first record containing Smith (i.e. Smith, Adam), despite me choosing Smith, Rob). I can...

3 linked tables. 1. tblClientInformation (linked one to many with tblWorkshopRegistrations via ClientID - primary key) 2. tblWorkshopListings - details of what workshops we offer (linked one to many with tblWorkshopRegistrations via WorkshopID - primary key) 3. Workshop Registrations (linked...

Perhaps a fix. How often is it the underlying table structure! I have created a new field in my snacks table. Called "Snack Type", for OJ, Water and Soda Pop, it has a value of Drinks. Problem solved. Thanks all who have given their time.

Thanks for the reply, I guess I am not explaining this correctly. (This is an example, my actual records / fields are much more relevant!) I have a table called "Snacks", two fields. SnackID (primary key) Snack (the records contain the actual data "popcorn, chocolate, etc.. etc.." This table...

This is killing me! It should be so simple, but I am having no luck. I have a table (for example called "Snacks")with 6 records (always these 6). 1 popcorn 2 chocolate 3 soda pop 4 orange juice 5 water 6 hot dogs I do queries and reports on these records seperately. But now I want to create a...