Adding to a Record

[ddrew]

I am building a database for running a shoot. I want to be able to add Firers, Beaters and Picker Ups to each day. All of those people are held in a [Contacts] form and have a checkbox to designate them as Shooters, Beaters or Picker Ups or a combination of them

I have a form where I can create the shoot date and timings etc. Now I want to add people to the form.

My idea is to have a seperate form with a list of all the Shoot Dates, on the same form will be three more lists showing Shoot Date and ID, List of all Guns, List of All Beaters, List of all Picker Ups in the Database.

You woud then select the shoot date from the first list which would highlight, then go each of the other three lists and select a checkbox next to each person that you wanted to attend that day.

I know what I want to do but dont know how to do it!

I have attached a picture to show my idea.

any thanks in advance.

 

[John Big Booty]

You'll need to use sub tables linked to the parent table via it's unique ID. This you would do using a form bound to your master (day record) and then a sub Form(s) for your sub records.

 

[ddrew]

Thanks for the reeply, but I dont really follow!

I guess I need to make three sub tables for Shooters, Beathers and PickerUps.

Thats about all I understand, sorry!

 

[John Big Booty]

Sorry I'm sitting in an Airport lounge at the moment, but I think the sample here may do the sort of thing you are after. If not, it's going to be a good 24 hours before I can find anything else

 

[ddrew]

Not really what Im after I dont think as I want to do it from one form. Have a good trip

I can wait till you have more time as there are other things to work on. Many thanks

 

[ddrew]

I've been working at trying to solve this but I'm getting nowhere fast, could someone please take a look? Many thanks