Stupid subform

[pablotx]

I am trying to get both of these forms to work together for data entry. I think my relationships are set right, but somehow along the way, the main form stopped working. Please take a look at the attached and point me in the right direction.

Thanks in advance

 

[Kiwiman]

Howzit

Try this..

What I changed

• Enforced referential integrity on your relationship
• this required the records 30-34 in your related table to be populated with a Client ID - I picked 5
• Added a subform to your Main form
• Changed some of the data options to allow edits\additions\deletions etc

You will need to look at normalisation - especially around repeating fields in your related tables - Product1, Product2

I hope this points you in the right direction. I'll be signing off for a few days - so good luck.

 

[missinglinq]

"the main form stopped working"

Stopped working in what way? The only obvious thing I saw was that the main form couldn't be edited; you had AllowEdits set to No. And, of course, you actually have no subform set up, despite the form name that would seem to indicate that you intended to use it as a subform.