Help please!

[nx69]

I want to have a form where a staff member will be able to book a bet. In the main form i want to have a Race list box, with the races, so in the subform i will be able to choose from a drop down menu only horses that are in tha particular race and not from all horses.
** e.g. I have entered 80 horses, 10 for each race. I want to be able to select only from the 8 horses that participate in race 401 for example and not from 80.

Thanks a lot.

Relationships:

 

[a.sinatra]

Search Cascading combo boxes, this should help ypu.
________
Roll blunts

 

[nx69]

Thanks

Search Cascading combo boxes, this should help ypu.

Thanks a lot.

Some more help would be more than welcome.
1. I want according to the type of bet, some combo boxes to appear. e.g. If the type of bet is Trio, where you have to find the first 3 horses, I want 3 combo boxes to appear where i will select the three horses. How can i do that?

2. I have two tables tblRace and tblHorses, with relationship, one-to-many. I want to create a form with a subform, where in the Race field i will enter the race number and in the subform i will choose a horse the is already entered in frmHorses. How can i do that?

 

[nx69]

Your tables still need some work. You have a many-to-many relationship between horses and races. To implement this you need three tables.

tblHorse:
HorseID
HorseName
BirthDate
OwnerID
etc.

tblRace:
RaceID
RaceDate
etc.

tblEntrants:
RaceID
HorseID
ElapsedTime

Then to handle wagering:

tblBet:
BetID
RaceID
BetType
BetAmount

Then because some bets are multi-horse:

tblBetHorse:
BetID
HorseID

Pat thanks for your reply. I dont think the problem is with the tables coz the relationship is one-to-many(one horse can particate ine one race and in one race can participate many horses).
However i cant use cascading box as i havent manage to understand how to create them. If someone could provide me with a "real" example, i will send him my database as it is 331.8 KB and it cannot be uploaded here. email: gianos@cytanet.com.cy

Thanks in advance.

 

[ColinEssex]

However i cant use cascading box as i havent manage to understand how to create them. If someone could provide me with a "real" example,

Have a look at the AccessFAQ - here's a good explanation by Mile-O-Phile

http://www.access-programmers.co.uk/forums/showthread.php?t=62408

Col