I have two databases, one for customer records and one for booking records.

In the booking form I have a relational subform displaying the customer information.
When entering new data everything is working fine.
I obviously also want to have the chance to search, retrieve, and display (bind) existing customer data to a new booking. The realtion is via a unique booking number and every customer records has a unique customer number.

I open a serach window from the subform to search the customer database but how do I get a record found to display in the subform?

Thanks for any help.
Carsten

Hello Carsten,

Can a customer be booked more than once? ex. Would the Joe Smoe customer record ever need to appear under more than one booking record?

-Ray

Hello Carsten,

If a customer can appear under several bookings then linking via the booking number will not work. Each customer can only have one booking number at a time, unless you get tricky.  There are a couple ways to do what you want to do.

The first way, the simple way, is to switch the relational link from the booking number to the customer number. Since only one customer is assigned per booking record, you just enter the customer number on the booking form and it will link in the customer information. If you ever need to book two customers to one booking record, not sure if you would, but you can do that as well with linking by the customer number.

The second way is a little trickier. You would need to turn the Booking Number field in the Customer database into a Keyword field. Then turn the Booking Number field in the Booking Database into a text field. At this point your linking will work like it does now, so you should see the same records. Note: You may need to run a Mass Update to strip the trailing zeros. But this way gives you the ability to link a customer record to any number of booking records, right from the customer form.

Ex: Say you want to add Joe Smoe, who is already booked in the 7206 booking, to the 42104 booking record as well. You would search the Customer Database for the Joe Smoe Record. In the booking number element the record currently has '7206'. You would just add ';42104' to the booking number element. So the final value in the Booking Number element of the Customer form would be '7206;42104'. This means that Joe Smoe would appear under both the 7206 booking and the 42104 booking.


-Ray

Hello Carsten,

A parent record will link in it's children when that record is loaded. So what you can do is program the parent form to advance(F10) one record and then move back one record(F9). You can use @SelectTreeItem() to select both of those choices off the Menu Tree.

Quote:


What sort of wildcard and delimiters did you have to use?

-Ray

Hello Carsten,

You want the programming to be on the form you are leaving, not on the form you are going to, and in the programming event where you leave the one form and go to the other. The code would be something like.

@SelectTreeItem() back to parent form
@SelectTreeItem() F10
@SelectTreeItem() F9
@Exit

-Ray