Dear All,
I have a very basic database design, which I have attached.
There are 2 specific objects I want to create within the database, and was wondering what sort of structure you might suggest, and any links you may have about creating the form and report that I need.
1. I want my form based on the tblActors - this is where I will be adding records. However I also want a subform(?) on there so I can 'attach' as many 'RoleName' from the tblRoles to each 'ActorID'. The subform should have a dropdown list restricted by the 'RoleName' field in the tblRoles.
2. I want to be able to generate a report that can show a list of all the 'ActorID's attached to each 'PlayName' in the tblRoles.
Any help anyone can give me would be very gratefully received! I know if I was just creating the form mentioned in part 1 it would be a one-to-many, but I think point 2 might complicate matters and make it a many-to-many?
I also have very little experience in creating the form and possible sub-form with dropdown list mentioned in point one.
Many Thanks,
Nick
I have a very basic database design, which I have attached.
There are 2 specific objects I want to create within the database, and was wondering what sort of structure you might suggest, and any links you may have about creating the form and report that I need.
1. I want my form based on the tblActors - this is where I will be adding records. However I also want a subform(?) on there so I can 'attach' as many 'RoleName' from the tblRoles to each 'ActorID'. The subform should have a dropdown list restricted by the 'RoleName' field in the tblRoles.
2. I want to be able to generate a report that can show a list of all the 'ActorID's attached to each 'PlayName' in the tblRoles.
Any help anyone can give me would be very gratefully received! I know if I was just creating the form mentioned in part 1 it would be a one-to-many, but I think point 2 might complicate matters and make it a many-to-many?
I also have very little experience in creating the form and possible sub-form with dropdown list mentioned in point one.
Many Thanks,
Nick
Attachments
Last edited: