Customer ID link

[ictcrystal]

hello
ive posted this question on a different forum but had no replies so i was hoping i would have some luck here


ive created a form that views appointments for today and alongside it has a subform that enables a dentist to enter details about a customer...

so the main form (apt today) displays customer ID
However in the subform it doesnt...


can someone tell me how i can make the form have both customerIDs appear automatically.

ive attached what i hope is relevant.

Any help would be wonderful
Attached Images

[June7]

Why did you blackout field names?

Customer should be selected from combobox list.

The form recordsource should not include customer and employee tables with INNER JOIN.

A form can do data entry/edit for only one table.

[ictcrystal]

Heya,

sorry its because it was part of my project and i didnt want my teacher to identify me hah.

I dont understand. i dont want it to be a drop down i just want it to automatically have the customers ID in the second form because the 2 are linked ( the left shows the customer who has the apppointment and the right is me entering details about them)

[June7]

That won't work because of the way tables are related. CustomerID needs to be saved into Appointment record. This is accomplished by selected CustomerID from a combobox list of customers. If you need to edit customer record or add a new customer, that must be done in a form that is not linked to the appointment form.