Appointment Default Address

[Matizo]

Hi everyone,

I tried to search this forum for similar topic but I couldn’t find anything that would match what I need.

I have 2 tables:

tblCustomers
CustomerID
FirstName
LastName
HouseNo
Street
PostCode
Town

tblAppointments
AppointmentID
CustomerID
Time
Date
NouseNo
Street
PostCode
Town

The thing is that the appointments are usually arranged in the customer’s house but sometimes it is in different place (therefore address details in the tblAppointments).
What I would like to do is create a form showing appointment details. There would be all the above fields included from the tblAppointments, customer’s last name & first name and the check box.
If the address would be the same as the customer’s address fields would show default address details from the tblCustomers. BUT if I would want to change the address I would have to tick off the check box “Default” and then enter the new details (when the check box is ticked then you cannot edit address details (they are locked)).

If that would be helpful I attached my database,
Thanks in advance
Matt

 

[Matizo]

I really stacked with this. If anyone have some ideas please let know.

Thanks in advance
Matt