Help with Access Relationships, please.

[delfishie]

I am trying to make a form from several tables so that you can enter new records via form, and the cascading update/delete will reflect new information in all tables.

However, I am encountering difficulties creating a form where new records can be added or even where all records can be viewed. The filtering is turned off, and all controls/the form itself are set to allow data changing. The relationship is one to many, where one is a primary key and the many are NOT foreign keys.

Also, is it possible to have the joined fields from all records but one hidden in the form so that cascading update/delete will automatically enter the same information into the join fields throughout the record?

Any suggestions? I would appreciate your help!

 

[JeremyNYC]

Look into using a subform. You'll want the data on the one side of the join to be in the main form and the data on the many side of the join to be in the subform.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.