Can you think of a better way of doing this? Enquiries form - LOADS of checkboxes?

[Sharky II]

Hi guys

DB is for a travel agency which has (mainly) 'set' trips which the customer may enquire about.

Client needs a form off the customer detials form which, when the custoemr is on the phone and says 'i'm interested your trips to china, spain, japan and fiji', the client can keep a list/track of what trips the customer has enquired about.

This is a useful and kinda necessary feature to have, as it means that if the company has a new trip to spain, they can call/contact all people who have enquired about going to spain etc.

Thing is - i don't know how to design the form. At the moment, i am thinking of having a form with about 30 tickboxes in it, and you check which trips the customer is interested in. (This form/table is linked to the customer via customerID - obviously)

This means that i could use my standard query by form method to search all forms where 'spain' is ticked - easy.

This method easy, but has problems - if a new trip is created, it is not automatically added to the list of checkboxes, and they'll have to call me each time they need an update. They want to be able to change it themselves.

So i thought of having a mechanism similar to the form/query/etc wizard - like a list box with all the trips on the left, and then have another one on the right with arrows where u can choose which trips they are interested in and they go across to the left? Or something!

I have no idea how to do this however, and no idea how to search this either (tis not as easy as the earlier checkbox idea)!

Can anyone think of a clever way to do this?

Cheers guys + gals

Edd

 

[Jack Cowley]

Edd -

I have not forgotten you. Just been a bit busy...

tblCustomers
CustomerID (PK and autonumber)
LastName
...other fields...

tblTrips
TripID (PK and autonumber)
Destination
...other fields if necessary...

tblCustomerTrips
CustomerTripsID (PK and autonumber)
CustomerID (FK)
TripID (FK)

Have a form/subform. Select the Customer in the mainform. Select destinations in the subform (combo box in the TripID field). Now you have a list of all the destinations the customer is interested in.... And your user can add new trips to the Trips table at any time.

hth,
Jack

 

[Sharky II]

hi mate!

no, i've already got all of that working!

i need something about trip ENQUIRIES - y'know, like the customer can choose 6 trips he's interested in - it has nothing at all (to be honest) to do with trips or the trip details or actualy booking/reserving a place on the trip

so like i say, it's just needs to be a quick method for recording places that customers are INTERESTED in!

Cheers!

 

[Jack Cowley]

Hmmm. You have lost me.... the table 'tblCustomerTrips' has that information.... What am I missing?

Jack

 

[Sharky II]

tblCustomerTrips has all teh info that the customer is GOING on. you only play with customerTrips when the custoemr is reserving/booking his place on the trip.

hey - remember the DB i sent you, it had loads of checkboxes on teh main customer form? they were to indicate (quickly and easily, while the customer is on the phone) which trips the customer had shown (even mild) interest in

They had nothing to do with what trips the customer actually goes on.

Hang on... do u mean basically make a new form/table called tblCustomerTrips which is then a subform and basically acts like the real tblTripDetails but shows which trips the custoemr is interested in?

ie, do exactly the same thing as i have done for the actual trips, but again for trip enquiries?

I'm making a meal of this

Cheers

 

[Jack Cowley]

I wouldn't show all the possible trips but only select the ones (from a combo box) that you customer expresses interest in. You could modify the table like this:

tblCustomerTrips
CustomerTripsID (PK and autonumber)
CustomerID (FK)
TripID (FK)
Booked (Yes/No)

Then if the customer books a trip you put a tick mark in the the Booked checkbox.

Jack