FK won't display in table when adding a new record.

[Heeeeelp]

Hi everyone,

I have two tables, "Projects" and "Payments", that are joined by a "CaseID" field. I have created a form to enter the payment information for each project. All data entered in the form is recorded in the table with the exception of the Case ID which should be the same as that in the "Projects" table. The Case ID appears as a blank in the Payments table. I have set the "required" property to no for the Case ID and the default to blank. An orphan record is being created each time I add a new payment. When I set the required property to "yes", access will not allow me to add a payment..I get a message stating that the case ID must be entered as it's a required property.

I would appreciate any help...

Regards,
TS

 

[PHV]

A common way is to have a main form bound to Projects and a linked subform bound on Payments.
Provided the relationships are properly set the subform wizard does the linking stuff automagically.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Heeeeelp]

Thank you for your prompt reply PH. I am sorry but I should have provided more details. I have a third table with Project Details. The Project Details table is the subform for the main form, Projects and that part is working properly. Both the Project Details and Payments tables link to the Project table by the Case ID. How do I get the Case ID to update in the Payments table as well?

 

[MajP]

Have two subforms, one for payments, one for project details all linked by CaseID. If real estate is a problem use a tab control and put the subforms on different pages.

 

[Heeeeelp]

Thank you both for your help. I got that part working.
TS