Selecting values from two fields and saving in one

[cathalfarrell]

Hi Everyone,

I apologise in advance if this question has been asked before, although I can find no threads similar to my problem. Any help you can offer would be greatly appreciated as I am not very educated when it comes to acces and sometimes struggle with some very basic stuff.

I am creating a medical database to record customer enquires and payments so I can produce invoices and intineries automatically.

I have essientailly three tables:
Enquiries
Bookings
Payments

I record an 'Equiry' record everytime I recive an enquiry from our online form. Once the customer has agrees to have surgery I record the details as a 'Bookings' record. I record any deposit or installments made as records in the 'Payments' table.

In the Enguiries table there are two fields for customers full name, 'first name' and 'surname'. When recording a booking I use the following to search by full name.

I have used the following
SELECT [Enquiry].[ID], [Enquiry].[First Name], [Enquiry].[Surname] FROM Enquiry ORDER BY [First Name], [Surname];

The problem arrises when I want to make a payment. I would like to be able to selcted the customer by combo box displaying the customer name
SELECT [Booking].[ID], [Booking].[Customer] FROM Booking;

The only value I am offered is the ID of the customer, which will make no sense when trying to identify the booking. How can I display the customer name instead?

I'm not sure if I have made myself very clear here so please don't hessitate to ask for more information if I have lefted anything important out.

Thanking you in advance,
Cathal

 

[Alansidman]

In your lookup, you will need to join the enquiry table and the booking table on the ID so that you can see the name in your query.

Alan