Q. I need to link from one field in a subform to a field in a different subform

[Jim Jones]

OH.

You were saying a Subform (or maybe you weren't and I was just reading
Subform).

No, if you use a Popup form THEY WILL NOT MAGICALLY FILL IN. You'll
need to use VBA code in the popup form's Open event to fill them in.

BUt my table structure question still remains, and has not been
answered:

OK, I will try to answer it like this:

The ServiceTicket field, even though set up as a one-to-many in
tables, does not show up on ServiceNotes, as neither does Customer
Number. Those fields are blank, even in the table, when I manually
open tables. I just added a new field called "NotesNumber" to give
ServiceNotes, its own unique number, but it does nothing.

WHY should the CustomerNumber be in the ServiceNotes table AT ALL!!?


You don't need it there. You know which ServiceRecord the note
pertains to, it's there in the foreign key; you know which car the
ServiceRecord pertains to, using its foreign key; and you know which
customer owns that car, using ITS foreign key.

The ServiceNote DOES NOT AFFECT the customer, directly. It does,
indirectly, but you have all the links you need to connect them. I
would assert that it is improper table design to have the
CustomerNumber field in *either* the ServiceRecords table *or* the
ServiceNotes table, since the identity of the customer is not a proper
attribute of either a Service entity or a Notes entity!

The fact remains that the pop-up form/table ServiceNotes opens with
blank fields, EVEN when I enter data into them.

Alt the fields except ServiceTicket will show up.

The pop-up form opens, as if it expects a brand new record.
OK, then I enter data, update the record, close the database.

When I re-open the database, nothing is on the pop up form, even when
I scroll to the related record on the ServiceTicket subform.

Now, as per your suggestion, I removed the CustomerNumber field, from
the pop-up form, and made sure there is no link in relationships.
Same thing happens. As if it doesn't matter.

So, you were right, it's not needed, but I still have the problem I
just described above.

Jim